techOMS Canonical Import Files [Information]

When performing procedures and actions that require file imports, you will need the appropriate templates to ensure all necessary fields and columns are included.

At the bottom of this article, you will find the following import templates:

• Sales
  • SO_Import_Orders.csv
• Purchases
  • PO_Import_Orders.csv
• Inventory
  • P_Products.csv
  • P_Product_Variant_References.csv
  • P_Product_Bundles.csv
  • P_Alternate_Products.csv
  • IL_Inventory_Levels.csv
• Fulfillment & Sales Channels
  • C_Carrier_Mappings.csv
  • C_SKU_Mappings.csv
    
    
    NOTE: The C_SKU_Mappings.csv file is used for SKU mappings in both sales and fulfillment channels. While the second column header references fulfillment channel SKU, the file structure applies to both channel types. 

    
    

• Admin Settings
  • Carriers.csv

NOTE: Additional files may be added as more functionalities support file imports.