Listing a Product to WooCommerce Using a Spreadsheet

This article explains how to list a product to WooCommerce using a spreadsheet.

 

What we'll cover:

  1. Downloadable Excel Template
  2. Required Fields
  3. Optional Fields
  4. Variation Listings
  5. Uploading Your Spreadsheet
  6. 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

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 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 Yes if you would like to be able to manage inventory through Solid Commerce. Default is Yes 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.

Listing_A_Product_To_Magento_Using_A_Spreadsheet_Update_Product_And_Marketplace.png

 

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.

MagentoInventoryUpload.png

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

 

Back to top

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.