How to Import Product Variant References via file [Step-by-step guide]

The most effective way to add product variant references to techOMS is by using the import feature. This guide walks you through the process. 

WARNING: If techOMS is not set as your Account's Master Product Source, we recommend importing or making changes directly in your Master Product Channel instead.



Otherwise, be aware that imported data:

• Will propagate to your non-master channels.
  
  
• Will not sync back to your designated Master Product Channel.
• May be overwritten during future synchronizations from the Master Product Channel.

Proceed with caution. For details, see: Understanding the techOMS Master Product Source [Information].

WARNING: Each file can contain up to 10,000 records. Going over this will cause data issues.



Do not attempt to use an exported file as a template for the import operation, as their data schemas differ. Always use the canonical template provided in the techOMS Canonical Import Files [Information] article.

NOTE: Make sure that you are operating at the right Vendor/Warehouse beforehand.

 

NOTE: The system supports comma (,), semicolon (;), and tab as delimiters. The only supported quotation mark character is double quote (").



Before you import the file, make sure each Reference row contains a Variant SKU, Reference Code, and Reference Value. An incomplete Reference row is invalid. Duplicate Reference Codes for the same Variant SKU are also invalid, including Codes that differ only by letter casing. 

 

To import product variant references:

1. Click Products from the left menu under the Inventory section.

2. Press Maintenance and click on Import Product Variant References.

3. Click on the Files field and select the file.

4. Press Import Product Variant References.