You may create new products in bulk using the Data Import tool.
This is useful when you are first deploying onto the RetailOps app and you need to migrate product data from your old system into RetailOps.
This may also be used to manage channels that don't have a direct integration with RetailOps.
Required Data in Import file
To import products, import a spreadsheet with the following data. We recommend using a CSV:
- Product Name
- MSRP Price
- Offer Price
- Media URLs
- Any other required product/SKU attributes
Please note: You must be sure that each row of data in your spreadsheet is unique to create unique SKUs.
* Known Issue: last line of spreadsheet does not import properly, must add anything to the end of the list. like in pic above type 'test' into row 15, so the full Data list imports.
Certain data requires special formatting before import. This includes media URLs, values nested in attribute groups, and multiselect attributes.
For media URLs, you must enter the data in the format below. Note the image tags followed by the > sign. Each image URL must be separated by a pipe "|" character:
For attributes with values nested inside of groups/folders, format the data on your spreadsheet as shown below:
- Create a spreadsheet file with the required data (specified above).
- Known Issue: Last line does not import add another line at the bottom list (see above)
- In the RetailOps web app, go to Administration > Data Import.
- Drag-and-drop your spreadsheet file into the designated area.
- After the import is complete (Status: Uploaded), click on the file Name.
- Either select an existing profile with the Import type of Product Import/Update or create a new profile with that Import type selected.
- For Column match mode, select headers.
- Check the SKU Optional box.
- For Update Mode, select Create only.
- Assign each of the columns to their respective fields.
- Be sure to differentiate between Product Attributes (applied to the entire product family) and SKU Attributes (applied only to the unique SKU in the family).
- If there are any errors, edit data as needed by clicking directly on the desired cell.
- When you have resolved all errors (or if there were none to begin with), press the [Apply changes] button.
- Uploaded - this indicates your file has been properly uploaded to the tool
- Preprocessing - a user has begun formatting the import file, but has not processed it
- Processing - the file is actively being imported. Some larger files can remain in this status for several minutes
- Processed - the file has been applied and no additional changes may be made