What dropdown should I use for my data import?

When doing a data import in Ordoro, there are multiple options on how to update the information in your Ordoro account. Below is a list of the example files for each data import.

IMPORTANT:

  • If you are not updating certain column(s), delete them from the file. Do not leave them blank.
  • If left blank, they will overwrite the existing data as blank.

Topics

  1. Archive Products
  2. Create Addresses
  3. Create Orders
  4. Create Products
  5. Create Purchase Orders
  6. Create Suppliers
  7. Create Tracking Numbers
  8. Create/Update Supplier SKUs
  9. Manage BOMs
  10. Manage Kits
  11. Add Orders To Batch
  12. Manage Product Tags
  13. Remove Supplier SKUs
  14. Unarchive Products
  15. Update Inventory
  16. Update Product Fulfillment
  17. Update Product Image
  18. Update Product/Sales Channel Bridge
  19. Update Products

Archive Products

Use this to archive your products in Ordoro. Fields include:

  1. SKU *Required

Create Addresses

Use this to add customer addresses to Ordoro. Fields include:

  1. Name
  2. Company
  3. Phone
  4. Fax
  5. Email
  6. Street1
  7. Street2
  8. City
  9. State
  10. Zip
  11. Country
  12. Reference Number

Create Orders

Use this when manually creating bulk orders in Ordoro. Fields included:

  1. Order ID *Required
  2. Order Date
  3. Notes from Customer
  4. Grand Total
  5. Product Amount
  6. Tax Amount
  7. Discount Amount
  8. Shipping Amount
  9. Shipping Type
  10. Ship to Name
  11. Ship to Company
  12. Ship to Email
  13. Ship to Phone
  14. Ship to Street 1
  15. Ship to Street 2
  16. Ship to City
  17. Ship to State
  18. Ship to Zipcode
  19. Ship to Country
  20. Bill to Name
  21. Bill to Company
  22. Bill to Email
  23. Bill to Phone
  24. Bill to Street 1
  25. Bill to Street 2
  26. Bill to City
  27. Bill to State
  28. Bill to Zipcode
  29. Bill to Country
  30. Line Product SKU *Required
  31. Line Product Name *Required
  32. Line Item Price
  33. Line Quantity *Required
  34. Line Notes
  35. Line Discount Amount
  36. Line Total Price

Create Products

This is for when you are manually creating a product in Ordoro. Fields included:

  1. SKU *Required
  2. Description *Required
  3. Price
  4. Weighted Average Unit Cost (cost of product for the company)
  5. Weight (lbs)
  6. Category
  7. Length (in)
  8. Width (in)
  9. Height (in)
  10. UPC
  11. ASIN
  12. Harmonized Code
  13. Country of Origin
  14. Customs Description
  15. Internal Notes
  16. Has Serial Numbers (True/False)

Create Purchase Orders

Use this when manually creating bulk purchase orders in Ordoro. Fields included:

  1. PO Number
  2. Supplier Name* – Required 
  3. Receiving Warehouse
  4. Shipping Method
  5. Payment Method
  6. Instructions
  7. Estimated Delivery
  8. Discount
  9. Shipping + Handling
  10. Tax
  11. SKU* – Required 
  12. Line Ordered Qty
  13. Supplier Unit Cost
  14. Line Discount​

Create Suppliers

Use this to add a new supplier to Ordoro in bulk. Fields include:

  1. Company *Required
  2. Phone
  3. Fax
  4. Email *Required
  5. Street1
  6. Street2
  7. City
  8. State
  9. Zip
  10. Country
  11. Reference Number

Create Tracking Numbers

Use this to add tracking numbers to orders in bulk. Fields Include:

  1. Order Number *Required
  2. Shipment Date *Required (Date and Time example: 2021-06-13 10:48:15.172949-05)
  3. Tracking Number *Required
  4. Carrier Name *Required
  5. Shipping Method
  6. Cost
  7. Notify Ship To
  8. Notify Bill To
  9. Notify Cart (set to TRUE if you want tracking synced to the Sales Channel)

Create/Update Supplier SKUs

Use this to update supplier information for your products. Fields include:

  1. SKU *Required
  2. Supplier *Required
  3. Supplier SKU
  4. Supplier Unit Cost
  5. Default Supplier
  6. Min Order Quantity
  7. Lead Time

Manage BOMs

This is used to either add or remove BOM components. Bill of Materials can be created or modified this way.

  1. SKU *Req
  2. Add Child SKU
  3. Remove Child SKU
  4. Quantity

Manage Kits

This is used to either add or remove components of kits. Kits can be created or modified this way.

  1. SKU *Req
  2. Add Child SKU
  3. Remove Child SKU
  4. Quantity

Add Orders To Batch

Use this to assign Orders to a particular Batch in bulk.

  1. Order Number *Required
  2. Batch ID *Required

Manage Product Tags

Use this to add or remove product tags in bulk.

  1. SKU *Required
  2. Add Tag
  3. Remove Tag

Remove Supplier SKUs

Use this to remove supplier assignments from products. Fields include:

  1. SKU *Required
  2. Supplier *Required

Unarchive Products

Use this to unarchive your products in Ordoro. Fields include:

  1. SKU *Required

Update Inventory

Use this to update product inventory in bulk. Fields include:

  1. SKU *Required
  2. Warehouse *Required
  3. Location in Warehouse
  4. Physical On Hand
  5. On Hand Adjustment
  6. Low Stock Threshold

Update Product Fulfillment

Use this to update product fulfillment status. Note: Not available for all accounts at this time. Fields include:

  1. SKU *Required
  2. Fulfillment Type *Required
  3. Supplier

Update Product Image

Use this to update or add an image URL to your product.

  1. SKU *Required
  2. URL *Required

Update Product/Sales Channel Bridge

Use this to update a product’s information sent to the sales channel on inventory writebacks. Fields include:

  1. SKU *Required
  2. Sales Channel Name *Required
  3. Amazon Fulfillment Channel
  4. Fulfillment Latency
  5. Max Export Quantity
  6. Min Export Quantity
    • Set this field as blank if you’d like to write negative inventory quantities back to the sales channel. For more details, see this support article.
  7. Percent Export Quantity
  8. Reserve Export Quantity
  9. Writeback Inventory

Update Products

This is used when you are updating a product’s information that already exists in Ordoro. Fields included:

  1. SKU *Required
  2. Description
  3. Price
  4. Weighted Average Unit Cost (cost of product for the company)
  5. Weight (lbs)
  6. Category
  7. Length (in)
  8. Width (in)
  9. Height (in)
  10. UPC
  11. ASIN
  12. Harmonized Code
  13. Country of Origin
  14. Customs Description
  15. Internal Notes
  16. Has Serial Numbers (True/False)