Skip to main content
Bulk catalogue work in CloudHub goes through Import and Export. You export a set of SKUs to a spreadsheet, edit in Excel, re-import, and CloudHub validates and writes the changes back to the master catalogue (and downstream to listings). This is how merchants run weekly price updates, seasonal range expansions, and end-of-line clearances at scale. This page covers the four surfaces in this part of CloudHub: Inventory Import, Inventory Export, FTP Price Change Log, and Product Export / Import Validation Status Monitor.

​
Import \

Inventory Import lives at Home > Optimise > Inventory Import. Open it from the [Optimise] services menu or from the Import Inventory action button on the Inventory Hub.

​
Import sub-tabs

The page has a tab strip across the top:
Sub-tabWhat it is for
AllThe default landing tab; runs an import that affects all marketplaces and the master record.
Admin Template MappingA super-admin surface to map a customer’s column header to CloudHub’s internal field.
Import Inventory ProfileThe list of saved import profiles you can pick from.
WebsiteWebstore-only import (Shopify or your own webstore).
Import Validation OnlyRun the import in dry-run mode. CloudHub validates the file and reports what would happen, without committing. Use this on big imports before pulling the trigger.
Import Mastermarketplace OnlyImport targeting only the marketplace listing rows, not the master record.

​
Running an import

  1. Choose the Import Profile from the dropdown. The screenshot example shows profiles like:
    • Amazon minmax price update
    • Amazon_ebay_PriceUpdate
    • ebay Product Title
    • ebay Title
    • Master Template 234 Columns
    • Weight Upload The profile determines which columns the import expects and which fields it writes to.
  2. Click Choose file and pick your edited CSV / Excel file. The filename appears in the File Location field.
  3. Confirm the Email Address field, comma-separated if you want notifications to multiple inboxes. CloudHub emails the validation result and final status here.
  4. Click the blue Import button. (Use Reset to clear the file and start over.)

​
Adding a new import profile

A small link “To add a new import inventory profile, please click here.” sits below the Import Profile dropdown. Click it to open the profile editor, where a super-admin can map columns from a custom file format to CloudHub fields and save it as a reusable profile.

​
Sample template downloads

The bottom half of the Import page lists the available templates with a download icon on each row:
Profile NameDownload
Amazon minmax price update(download icon)
Amazon_ebay_PriceUpdate(download icon)
ebay Product Title(download icon)
ebay Title(download icon)
Master Template 234 Columns(download icon)
Weight Upload(download icon)
The page footer notes:
Select Import template, download the sample file and import the file.
The pagination control (10 / 25 / 50 / 100) sits on the right.

​
Export \

Inventory Export lives at Home > Optimise > Inventory Export. Open it from the [Optimise] services menu or from the Export Inventory action button on the Inventory Hub.

​
Export tabs

The Export page has two tabs:
  1. Create Profile: define a new export profile.
  2. Template Column Mapping: map columns of an existing profile to CloudHub fields.

​
Saved profiles list

Below the tabs, a table lists saved export profiles. Columns:
ColumnWhat it shows
Profile NameThe friendly name. Examples from the screenshot: Master Export, DK Pricing 2024.
Created ByThe user who created the profile.
Created OnThe creation timestamp.
Modified ByThe user who last edited it.
Modified onThe last-edit timestamp.
ActionsA pencil icon (edit) and a red bin icon (delete).

​
Creating a new export profile

  1. Click Create Profile tab.
  2. Type a Profile Name in the input.
  3. Click Save.
  4. Switch to Template Column Mapping to choose which fields the profile exports.
  5. Save the column mapping.
The new profile is now selectable from the Inventory Hub Export Inventory action.

​
Running an export

You do not run exports from this configuration page directly. Exports are triggered from the Inventory Hub using the Export Inventory action button, which lets you pick a profile and the rows to export.

​
FTP Price Change Log

Some merchants run pricing via an FTP feed (their ERP drops a CSV onto an SFTP server and CloudHub picks it up on a schedule). The FTP Price Change Log is the audit history of those price-via-FTP events.

​
What it shows

Each row is one FTP-driven price change attempt:
  • Timestamp of the FTP pull.
  • File name that triggered the change.
  • SKU affected.
  • Old Price and New Price.
  • Status: success, validation error, write failure.
  • Error detail if status is not success.
Use this log when a merchant says “the price changed and we did not change it manually”. The FTP feed is usually the answer, and the log proves which file did it.

​
How to find it

From the Inventory Hub action bar: Import / Export Log. Or via the [Optimise] services menu under FTP Price Change Log.

​
Product Export / Import Validation Status Monitor

This is the dry-run companion to Import. When you run an import in Import Validation Only mode, the result lands in this monitor. It shows you exactly what would happen if the import had committed, so you can fix issues before writing to the master.

​
Columns

ColumnWhat it shows
Job IDThe unique import job identifier.
File NameThe uploaded file.
Submitted ByThe user who ran the validation.
Submitted AtThe timestamp.
Validation StatusPass, Fail, or Partial.
Rows TotalHow many rows the file contained.
Rows ValidHow many would commit cleanly.
Rows InvalidHow many would fail.
Error ReportDownload link for the per-row error CSV.

​
Workflow, validate then commit

  1. Run import in Import Validation Only mode.
  2. Open the Validation Status Monitor.
  3. Wait for the row to flip from Running to Pass / Fail / Partial.
  4. If Fail or Partial, download the Error Report and fix the rows in your file.
  5. Re-run validation to confirm.
  6. Once validation is Pass, re-run the import without the Import Validation Only flag.
This pattern is mandatory for files over a few thousand rows. Importing 50,000 rows blind without dry-run validation is the fastest way to corrupt a catalogue.

​
Common workflows

​
Weekly price update across Amazon and eBay

  1. Use Master Export (or a custom price-only profile) to export the SKUs you want to reprice.
  2. Edit Min and Max prices in Excel.
  3. Run Import Validation Only with the Amazon_ebay_PriceUpdate profile.
  4. Confirm validation is Pass in the Validation Status Monitor.
  5. Run the actual import.
  6. The price change pushes to both Amazon and eBay listings on the next sync cycle.

​
Title cleanup on eBay

  1. Export with ebay Product Title profile.
  2. Edit titles in Excel.
  3. Validation-only import.
  4. Commit.
  5. eBay listings update on next sync.

​
Bulk weight load before a Royal Mail integration

  1. Export with Master Export to pick up SKU and current weight columns.
  2. Update weights in Excel.
  3. Import with Weight Upload profile.

​
Common questions

My import says “validation passed” but the prices did not change on Amazon. Validation passing means CloudHub accepted the file and the master record was updated. The push to Amazon happens on the next marketplace sync cycle, which is minutes-to-hours depending on the marketplace and your rate-limit budget. Check the Listing Status Monitor for the push status. The import is stuck on “Running” in the Validation Status Monitor. Large files take longer; tens of thousands of rows can take ten or more minutes. If it is still running after an hour, contact support with the Job ID. Can I delete a saved import profile? Yes, from the saved profiles list in the [Configure] section. The Inventory Import surface only lets you select; profile management lives in [Configure]. My CSV has UK pound signs in the price column and the import fails. CloudHub expects numeric price values without currency symbols. Strip the £ characters in Excel before saving as CSV, or save as CSV (UTF-8) so encoding is preserved. The FTP Price Change Log shows a change I did not make. Your ERP or another upstream system is publishing the price file. The log shows the file name; the file owner is whoever is publishing to the SFTP server. Coordinate with that team.

​
Next steps

  • Open the Inventory Hub to trigger an import or export from the action bar.
  • Add a single SKU manually with Add a Product.
  • Audit pushes on the Listing Status Monitor.
  • Set up an FTP price feed via [Configure] > Email and FTP Settings (documented in a later batch).