Create or update External SKU data in bulk via the Data Import tool

To upload new or updated data for your External SKUs, like new vendor external inventory, you can do it manually in the PIM [See article here for details] or with a bulk file in the Data import tool. 

Available data to upload

To update or create new external inventory entries, upload a TSV or CSV file containing the following data: 

• SKU
• Vendor 
• VPC
• External SKU - Est Days
• External SKU - Unit Cost
• Vendor Inv Advice

Directions

1. Create a spreadsheet file with the data specified above. Requires SKU & Brand to match correctly if updating Data.
2. In RetailOps, open the Data Import tool from the left navigation menu.
3. Drag-and-drop your spreadsheet file into the designated area.
4. After the import is complete, click on the file Name.
5. Either select an existing profile with the Import type of Product Import/Update or create a new profile with that Import type selected.
6. Select the Update Mode.
7. For Column match mode, select headers.
8. Assign each of the columns to their respective fields.
   • For VPC updates, select "Allow VPC change"
9. If there are any errors, edit data as needed by clicking directly on the desired cell.
10. When you have resolved all errors (or if there were none to begin with), press the [Apply changes] button.