When doing a data import in Ordoro, you will want to know which dropdown option to choose when updating information on your Ordoro account. You can figure this information out by downloading the example file of each dropdown.

IMPORTANT: If you are not updating certain columns, please delete the columns out of the file, do not just leave them blank. If left blank, they will overwrite the existing data as blank.

For ease of use, see the fields you can update from each dropdown option on the data import in Ordoro.

  1. Create Products – This is for when you are manually creating a product in Ordoro. Fields included:
    • SKU *Required
    • Description *Required
    • Price
    • Weighted Average Unit Cost (cost of product for the company)
    • Weight (lbs)
    • Category
    • Length (in)
    • Width (in)
    • Height (in)
    • UPC
    • Harmonized Code
  2. Update Products – This is used when you are updating a product’s information that already exists in Ordoro. Fields included:
    • SKU *Required
    • Description
    • Price
    • Weighted Average Unit Cost (cost of product for the company)
    • Weight (lbs)
    • Category
    • Length (in)
    • Width (in)
    • Height (in)
    • UPC
    • Harmonized Code
  3. Create Purchase Orders – Use this when manually creating bulk purchase orders in Ordoro. Fields included:
    • PO Number
    • Supplier Name* – Required 
    • Receiving Warehouse
    • Shipping Method
    • Payment Method
    • Instructions
    • Discount
    • Shipping + Handling
    • Tax
    • SKU* – Required 
    • Line Ordered Qty
    • Unit Cost
    • Line Discount​
  4. Create Orders – Use this when manually creating bulk orders in Ordoro. Fields included:
    • Order ID *Required
    • Order Date
    • Notes from Customer
    • Grand Total
    • Product Amount
    • Tax Amount
    • Discount Amount
    • Shipping Amount
    • Shipping Type
    • Ship to Name
    • Ship to Company
    • Ship to Email
    • Ship to Phone
    • Ship to Street 1
    • Ship to Street 2
    • Ship to City
    • Ship to State
    • Ship to Zipcode
    • Ship to Country
    • Bill to Name
    • Bill to Company
    • Bill to Email
    • Bill to Phone
    • Bill to Street 1
    • Bill to Street 2
    • Bill to City
    • Bill to State
    • Bill to Zipcode
    • Bill to Country
    • Line Product SKU *Required
    • Line Product Name *Required
    • Line Item Price
    • Line Quantity *Required
    • Line Notes
    • Line Discount Amount
    • Line Total Price
  5. Create Tracking Numbers – Use this to add tracking numbers to orders in bulk. Fields Include:
    • Order Number *Required
    • Shipment Date *Required (Date and Time example: 2021-06-13 10:48:15.172949-05)
    • Tracking Number *Required
    • Carrier Name *Required
    • Shipping Method
    • Cost
    • Notify Ship To
    • Notify Bill To
    • Notify Cart
  6. Update Inventory – Use this to update product inventory in bulk. Fields include:
    • SKU *Required
    • Warehouse *Required
    • Location in Warehouse
    • Physical On Hand
    • Low Stock Threshold
  7. Create/Update Supplier SKUs – Use this to update supplier information for your products. Fields include:
    • SKU *Required
    • Supplier *Required
    • Supplier SKU
    • Supplier Unit Cost
    • Default Supplier
    • Min Order Quantity
  8. Remove Supplier SKUs – Use this to remove suppler assignements from products. Fields include:
    • SKU *Required
    • Supplier *Required
  9. Create Kit – Use this to bundle already created products together as kits in Ordoro. Fields include:
    • SKU *Required
    • Child SKU *Required
    • Quantity *Required (the quantity required to create a kit)
  10. Update Kit – Use this to update SKUs in bulk, in particular, just change the quantity in kit. Fields include:
    • SKU *Required
    • Child SKU *Required
    • Quantity *Required (the quantity required to create a kit)
  11. Create Suppliers – Use this to add a new supplier to Ordoro in bulk. Fields include:
    • Company *Required
    • Phone
    • Fax
    • Email *Required
    • Street1
    • Street2
    • City
    • State
    • Zip
    • Country
    • Reference Number
  12. Create Addresses – Use this to add customer addresses to Ordoro. Fields include:
    • Name
    • Company
    • Phone
    • Fax
    • Email
    • Street1
    • Street2
    • City
    • State
    • Zip
    • Country
    • Reference Number
  13. Archive Products – Use this to archive your products in Ordoro. Fields include:
    • SKU *Required
  14. Unachive Products – Use this to unarchive your products in Ordoro. Fields include:
    • SKU *Required
  15. Assign Dropship Suppliers – Use this to assign suppliers to your products. Fields include:
    • SKU *Required
    • Supplier *Required
  16. Update Product Fulfillment – Use this to update product fulfillment status. Fields include:
    • SKU *Required
    • Fulfillment Type *Required
    • Supplier

      Note: Not available for all accounts at this time.
  17. Update Product/Sales Channel Bridge – Use this to update a product’s information sent to the sales channel on inventory writebacks. Fields include:
    • SKU *Required
    • Sales Channel Name *Required
    • Amazon Fulfillment ChannelFulfillment Latency
    • Max Export Quantity
    • Writeback Inventory
  18. Update Product Image – Use this to update or add an image URL to your product.
    • SKU *Required
    • URL *Required
  19. Manage Product Tags – Use this to add or remove product tags in bulk.
    • SKU *Required
    • Add Tag
    • Remove Tag

Leave a Reply

Your email address will not be published. Required fields are marked *