How do I create an appropriate Add to Cart button, CSV file using Excel?
The CSV columns are as shown below:- Product name.
- *Product description.
- *Product price.
- *Product quantity type (ALLOWINPUT or PREDEFINED).
- *Product quantity.
- Product part number.
- Product handling.
- Product shipping method.
- Product weight.
- Product drop ship zip code.
- Product exempt status.
- Product discount.
- Product ESD file.
- Product Graphic URL.
* Indicates a required field.
After entering all your products into Excel, in the format shown above, do the following:- In Excel, click on "Save As" under "File".
- In the "Save as type" field choose "CSV".
- Name the file and click on "Save".
- Close Excel.
You may now upload this CSV file into the cart.
Example CSV File |