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.

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:
    1. SKU *Required
    2. Description *Required
    3. Price
    4. Weighted Average Cost (Cost of product for the company)
    5. Weight (lbs)
    6. Category
    7. Length (in)
    8. Width (in)
    9. Height (in)
    10. UPC
    11. Harmonized Code
  2. 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 Cost (Cost of product for the company)
    5. Weight (lbs)
    6. Category
    7. Length (in)
    8. Width (in)
    9. Height (in)
    10. UPC
    11. Harmonized Code
  3. 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
  4. Create Tracking Numbers – Use this to add tracking numbers to orders in bulk. Fields Include:
    1. Order Number *Required
    2. Shipment Date
    3. Tracking Number *Required
    4. Carrier Name *Required
    5. Shipping Method
    6. Cost
    7. Notify Ship To
    8. Notify Bill To
    9. Notify Cart
  5. 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. Low Stock Threshold
  6. 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 Price
    5. Default Supplier
    6. Min Order Quantity
  7. Create Kit – Use this to bundle already created products together as kits in Ordoro. Fields include:
    1. SKU *Required
    2. Child SKU *Required
    3. Quantity *Required (the quantity required to create a kit)
  8. Update Kit – Use this to update SKUs in bulk, in particular, just change the quantity in kit. Fields include:
    1. SKU *Required
    2. Child SKU *Required
    3. Quantity *Required (the quantity required to create a kit)
  9. 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
  10. 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
  11. Archive Products – Use this to archive your products in Ordoro. Fields include:
    1. SKU *Required
  12. Unachive Products – Use this to unarchive your products in Ordoro. Fields include:
    1. SKU *Required
  13. Assign Dropship Suppliers – Use this to assign suppliers to your products. Fields include:
    1. SKU *Required
    2. Supplier *Required
  14. Set Automatic Dropshipping – Use this to set products to automatically dropship or not. Fields include:
    1. SKU *Required
    2. Is Automatic *Required
  15. 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 ChannelFulfillment Latency
    4. Max Export Quantity
    5. Writeback Inventory

Leave a Reply

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