techOMS Canonical Import Files [Information]

Modified on Wed, 25 Mar at 12:16 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.


This article provides the canonical import templates available in techOMS and links to their corresponding instruction guides.

 

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

 

Import Templates


The table below details the available import templates categorized by module, including the specific file name and the related instruction guide. The actual CSV files are available for download in the attachments section at the bottom of this article.

 

CATEGORY
FILE NAME
IMPORT INSTRUCTIONS
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
All Channels
(Fulfillment and Sales)

C_Carrier_Mappings.csv
C_SKU_Mappings.csv
Fulfillment Channels
F_Reference_Mappings.csv
Admin Settings
Carriers.csv
 
Customers.csv

 

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

 

 
NoteAdditional 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