techOMS Canonical Import Files [Information]

Modified on Wed, 23 Apr at 12:52 PM

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


WARNING: Exported files may differ from import templates. Always use the provided import templates to ensure compatibility and avoid errors or data corruption.


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


CATEGORY
FILE NAMEIMPORT INSTRUCTIONS
SalesSO_Import_Orders.csvImport Sales Orders
Purchases

PO_Import_Orders.csv

Import Purchase Orders
Inventory

P_Products.csv

Import Products

P_Product_Variant_References.csv

Import Product Variant References

P_Product_Bundles.csv

Import Product Bundles

P_Alternate_Products.csv

Import Alternate Products

IL_Inventory_Levels.csv


Fulfillment & Sales Channels

C_Carrier_Mappings.csv

Import Carrier and Service Mappings in a Fulfillment Channel
Import Carrier and Service Mappings in a Sales Channel

C_SKU_Mappings.csvMap SKUs in a Fulfillment Channel
Map SKUs in a Sales Channel

Admin Settings

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


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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article