How to import sales invoice with product that has 2 variant options? Currently it will mention product variant ’38 BLACK’ not exists.


Please refer to the Product > Product Variants.

You need to use vertical slash (also known as pipeline symbol) character "|" to separate Variant 1 Option and Variant 2 Option at the excel, example: “38|BLACK”.

Now you should successfully import.

View the Invoice:

You may refer to import from excel guide, click into the tab “Guide” in the template.

By: Aimi 240201, Lay Swan 240219, Jae Sen 240401