How to Import a Product

See this video for a tutorial.

These are the checklists that you need to accomplish for each import.

1. Copy the first paragraph in “Product description” to “Product short description”.

    2. Create “Attributes” so that the cartesian products of the new attributes match all the options.

    3. Setup the attributes in product variations.

    4. Tick the correct price range boxes (multiple allowed) based on the prices of the product variations. See the following picture.

    5. Save the progress.

    6. Edit the pictures to remove any Chinese characters. Add text for dimensions and other simple information.


    1. All option names start with lower cases and remain lower cases, except for names. The following picture shows the wrong mixing cases.

    2. All option values start with upper cases, except for names. The following picture shows a mistake of capitalizing all first letters.

    3. The naming of option values need to be consisitent. For example, for shape, we should do “Drum | Bowl”, not “Drum | Bowl Shaped”. The following picture shows the inconsistency.

    4. You must choose the appropriate values for the new attributes and cannot leave them blank or “Any value”. Otherwise, the prices for the variations won’t show up. You can check that the attribute values are filled in properly by going to product preview and choose the configurations to show prices. If product price is now shown, that means some attribute values are missing. The following picture shows some missing attribute values.

    5. Do not mix independent attributes into one. For example, coffee table and TV cabinet should be two independent attributes, they should not be mixed into one. The following picture shows a mistake of mixing them together. The new attributes can be, for instance, coffee table: “Yes | No”, and TV cabinet: “Standard | Slate | No”.

    5. When you are new, do not delete the original attribute “sort by color” for now. We cannot double check your new attributes with the old one to verify the correctness.

    6. When breaking down the original big attribute into small ones, you need to do some thinking. Some texts in the big attribute description are *not* values, they are merely descriptions. We should skip those in creating new attributes. For example, the following picture wrongly create attributes for “number of piece” and “for one person”. These are merely descriptions that should be skipped.

    7. Do not create an attribute for one that has only one option. There is nothing to select. The following picture shows a wrongly added attribute where “Oval” is the only option.