Update Data in Bulk Files

• PO Manifest. Upload a purchase order manifest to receive items against it.
• Markdown. Modify the Price or MSRP of SKUs.
• Lot Cost Update. Modify the Unit Cost of Lots.
• Bulk Media Edit. Deactivate product images.
• Product Import/Update. Modify product attributes, create new products.
• Map Table. Find predefined input values and replace those with predefined output values.
• Vendor. Add and update vendors’ profiles and contact information.
• Dropship Tracking. Track orders fulfilled by vendors and update the inventory.
• Inventory Quantity. Modify inventory levels for products.
• Customer Orders. Import new customer orders.

1. In the navigation menu, go to Administration > Data Import.
2. Drag and drop the desired upload file from your computer into RetailOps.
3. After the upload is complete (Status: Uploaded), click on the file.

Data Import File Statuses:

• 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

Profiles are used to streamline recurring tasks. For each profile, RetailOps saves the Import Type and Column Match Mode settings. RetailOps also saves the attributes you assign to each header. When you perform the task a second time--provided the headers of your second upload file matches those of the first--RO will recognize the header and select the correct attribute based on your first selections.

To create a new profile:

1. In Select profile, select new profile.
2. Enter a Profile name. We recommend using a name that identifies the recurring task you will perform with this profile.
3. Select the correct Import type.
4. For Column match mode, if your upload file contains headers, select headers. If not, select offsets. We recommend using headers whenever possible.
5. If, for Import type, you selected PO Manifest, Product Import/Update, Map Table, or Dropship Tracking, additional settings will populate on the right. Adjust these as needed.

Header attributes ensure the uploaded data is sent into the correct data fields in RetailOps.

1. Click on the header bar for any column marked unassigned.
2. Under Use this column for, select the correct attribute. As you scroll through selections, a short description of the attribute will appear at the bottom.
3. Repeat these two steps above for every unassigned column.

1. If there are any errors in the data, the [Error] button will display the amount of errors. Click on the button to show only the rows with errors (displayed in red) and hide all others.
2. For each error, hover over the Status. A message will appear indicating the attribute causing the error and how to correct it.
3. Click on the attribute causing the error. Edit the data as instructed by the Status message.
4. Click away from the attribute. If the edited data is acceptable by RetailOps, the Status will change to “ok” and the row will turn green.
5. When you have resolved all errors (or if there were none to begin with), click the [Apply changes] button.