All Collections
FAQs and Troubleshooting
How To Use CrystalCommerce
How to format an exported order CSV for use with the Mass Create system
How to format an exported order CSV for use with the Mass Create system

Now that I have exported a list of items and their details from my order, how do I format the export so I can use it with Mass Create?

Dan McCarty avatar
Written by Dan McCarty
Updated over a week ago

When you export a list of order items from an order, the system generates a CSV file.
When opened with a spreadsheet editing program, the CSV looks like this:

Important: The notice on line 1 references the column headings on line 4, the "--Qty--" and "--Variants--" entries. These entries are invalid, and must be modified by you before the CSV file is ready for use in the Mass Create tool.

The --Qty-- column

The value '--Qty--' is invalid, and must be changed to one of the following two values:

  1. Qty

  2. Add Qty

QtyIf you use "Qty" as the column heading, the Mass Create tool assumes you are setting the quantity for each line item in the CSV. In our example file, Mass Create would set the quantity of Retreat to Coralhelm - Foil (Light Play, English) to 2.Add Qtyif you use the value "Add Qty" for the column heading, the Mass Create tool will adjust the current quantity for each line item in the CSV. In our example file, the Mass create tool would add 2 to the quantity of Retreat to Coralhelm - Foil (Light Play, English). Using "Add Qty" with positive numbers (like '2' in our example file) has the effect of adding the items in the current CSV back into stock. However, if you use negative numbers in the "Add Qty" column, that would remove the quantity from stock. If we were using the changed our example file to '-2' on line 5, Mass Create would remove 2 quantity from the existing stock in  Retreat to Coralhelm - Foil (Light Play, English).

The --Variants-- Column

Because variants are not consistent from one product type to another, and because orders may contain items from mixed product types, it is not possible to export a single CSV with perfectly structured variant data. This area of the CSV will display the variant values that are present for each line in the CSV, but it will be up to you to name the columns correctly. For reference, the most common variant is "Condition," and many product types also have a "Language" variant as well. In our example, the export contains only products from Magic Singles, so I would change the placeholder to "Condition" and add a new value "Language" in the next column. The final version of line 4 would look like:Product Name, Category, Qty, Condition, Language

Delete the top 3 lines

The top three lines of the CSV are there as an aid, but they are invalid for use in the Mass Create tool. Make sure to remove these rows before you save your final CSV. 

Did this answer your question?