Update Data in Bulk Files

The Data Import Tool allows users to upload bulk file updates directly through the RO interface. This currently applies to the following data file uploads or Import Types.

Import Types

  • 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.
  • 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.

Upload the File

  1. In the navigation menu, go to Administration > Data Import.
  2. Drag and drop the desired upload file from your computer into RO.
  3. After the upload is complete, click on the file.
Upload the File

Create New Profiles

Profiles are used to streamline recurring tasks. For each profile, RO saves the Import Type and Column Match Mode settings. RO 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.
Create New Profiles

Assign Header Attributes

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

  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.
Assign Header Attributes

Validate Data

  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 RO, 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.
Validate Data
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk