How to Import Products via file [Step-by-step guide]

Modified on Thu, 24 Jul at 12:04 PM

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

WARNING: This feature is only available when the Account's Master Product Source is set to techOMS. To learn more, see Understanding the techOMS Master Product Source [Information].

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

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 (").

To import products:

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

2. Press Maintenance and click on Import Products.

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

4. Press Import Products.

NOTE: You can download the canonical template file in techOMS Canonical Import Files [Information]. It includes 1 SKU with 2 variants.

Alternatively, you can export your current product list by following How to Export Products as a CSV file [Step-by-step guide] and use it as a template for your import. This is useful for bulk updates or for building a new import file based on existing data.

WARNING: Duplicate checking is based on the SKU Code. If there’s a conflict during import or product creation, techOMS will display an error message describing the issue.