This article explains how to list a product to WooCommerce using a spreadsheet.
What we'll cover:
- Downloadable Excel Template
- Required Fields
- Optional Fields
- Variation Listings
- Uploading Your Spreadsheet
- Related Articles
Downloadable Excel Template
This Excel template includes all the required column headers in addition to many optional ones. Refer to the tables below for valid values and examples.
NOTE: In the Solid Commerce Add-In in Excel, click Turn Inline help ON to enable valid value drop-down menus.
Required Fields
This table includes the minimum column headers required to list a product to WooCommerce, assuming you have already created the product in Solid Commerce and added quantity. For instructions, see Creating and Editing a Product Using the Solid Commerce Excel Tool and Updating Quantity, Cost, and Storage Location.
| Field Name | Field Description and Valid Values |
| results |
Leave this field blank. It will automatically populate if you upload the file using the Solid Commerce Excel Add-In Tool. *Do not include this column if you are uploading through the Web Uploader in your Solid Commerce account instead of using the Excel Add-In Tool. |
| product custom sku |
The SKU of your product. EXAMPLE: ABC123 |
| warehouse id |
The Warehouse ID of your product. EXAMPLE: ABC123 |
| list name | The name of your WooCommerce Market List in Solid Commerce. |
| po sources |
The name of the Warehouse(s) Solid Commerce should use as the inventory source for your listings. |
| mystore sell price exp |
This field controls the price of your item on WooCommerce. One option is to enter a number without a currency symbol. The other option is to enter the word cost, or simple formulas with the word cost, such as cost*1.5 or cost+5. More complex formulas like cost*1.2+5 or ((cost*1.2)+5) work as well. |
| mystore qty exp | Enter lq in this field if you want to make your entire inventory available on WooCommerce. You can also enter formulas. See Using the Listing Quantity Expression to Control the Quantities on Your Listings for more. |
| product attribute:woocommerce short_description | Enter a short description of the item |
| product attribute:woocommerce avail_view |
Enter TRUE to make the item public and FALSE to make the item private on WooCommerce.
|
| product attribute:woocommerce categories_ids | Enter the numerical value associated with your WooCommerce category in which you would like to place the item. Separate multiple values with commas. Do not include any spaces. |
| product attribute:woocommerce manage_stock | Enter TRUE if you would like to be able to manage inventory through Solid Commerce. Default is TRUE if left blank. |
| market auto rule |
The name of the MyStore Pricing Rule you want to use on your listing. MyStore Pricing Rules specify how we should set your price. See Creating a My Store (MyStore) Pricing Rule for more information. |
| run mystore | Enter Yes or No. |
Optional Fields
| Field Name | Field Description and Valid Values |
| mystore title |
If you prefer to use a listing title in WooCommerce that is different than the proudct name, supply your listing title. If you would like to simply use the product name as the listing title, leave this field blank. |
| product attribute:woocommerce avail_sale |
The date the sale price will begin overriding the product's standard price on WooCommerce. |
| mystore sale start date |
The date the sale price will begin overriding the product's standard price on WooCommerce. Use the format "YYYY-MM-DD". Use the text format in Excel to preserve the format of the column. |
| mystore sale end date |
The last date the listing should be available at the sale price. Use the format "YYYY-MM-DD". Use the text format in Excel to preserve the format of the column. |
| mystore on sale price exp |
This field controls the sale price of your item on WooCommerce. Enter the sale price of the listing without any currency symbol. If you have populated the cost field in Solid Commerce, you may enter a formula that incorporates the word cost. |
Variation Listings
Listing variations with Solid Commerce is possible.
See Creating Variation Listings on WooCommerce Using a Spreadsheet to learn more.
Uploading Your Spreadsheet
To upload through the Excel Add-In Tool:
We recommend including the WooCommerce Product Attributes with your other Product level fields. That way you can populate them when you create your products. The attached template is set up this way.
To upload the WooCommerce tab of the file using our Excel Add-In Tool, click the Upload Data button. Check only the Update Marketplace box.
To upload through the web uploader:
Go to the Products menu -> Import Products and Inventory. Check only the Import Marketplace box. Select MyStore from the Select marketplace drop-down.
If you include the WooCommerce Product Attributes, or any other Product Level fields, with your WooCommerce data, you will need to check both Product and Marketplace during the upload.
NOTE: Our listing service runs on a cycle. It may take up to 10 minutes for us to submit your automated items to WooCommerce.
Related Articles
- Connecting to a WooCommerce Webstore
- Creating Variation Listings on WooCommerce Using a Spreadsheet
- Creating a My Store (MyStore) Pricing Rule
- Creating and Editing a Product Using the Solid Commerce Excel Tool
- Updating Quantity, Cost, and Storage Location
Comments
Article is closed for comments.