Use an Excel workbook to create or update products in AtomicSeller. The first row must contain the exact header names listed below.
Before you start #
- Use an .xlsx workbook.
- Do not use formulas in the cells. Paste calculated values before uploading.
- Keep identifiers such as
SKUandGTINas text so Excel does not change them. - One row represents one product. Unknown columns are ignored.
Upload the file #
- Open Tools > Upload files.
- In Upload products file, select Choose File.
- Choose the workbook, then select Upload.
- Review the imported products in the Products area.
Supported headers #
| Header | Requirement | Description |
|---|---|---|
| SKU | Mandatory | Unique product reference. |
| MERCHANTKEY | Mandatory | Merchant reference configured in AtomicSeller. |
| STOREKEY | Optional | Store reference, when the product is linked to a specific store. |
| PRODUCTNAME | Optional | Full product name. |
| GTIN | Optional | EAN/GTIN barcode. Format this column as text to preserve every digit. |
| PRICEEXCLTAX | Optional | Unit price excluding tax; useful for customs declarations. |
| PHYSICALSTOCK | Optional | Physical stock quantity supplied by the WMS. |
| TAX | Optional | Tax amount or rate used for customs data. |
| PRODUCTWEIGHT | Optional | Unit product weight. |
| PRODUCTWIDTH | Optional | Product width. |
| PRODUCTDEPTH | Optional | Product depth. |
| PRODUCTLENGTH | Optional | Product length. |
| PRODUCTHSCODE | Optional | Harmonized System code used for customs. |
| UNCODE | Optional | UN code used for IATA dangerous-goods information. |
Download a sample #
Start with this sanitized workbook and replace the demonstration values with your own data.
Troubleshooting #
- If a product is not imported, check that
SKUandMERCHANTKEYare present. - If a barcode is displayed in scientific notation, format the
GTINcolumn as text and enter the value again. - Keep the header spelling unchanged; extra columns that AtomicSeller does not recognize are skipped.