Creating New Listings on Shopify Using a Spreadsheet

This article will show you how to use a spreadsheet to create new listings in your Shopify webstore.

Before you list products, you need to connect to Shopify, create a Market List, and create a My Store Pricing Rule. See the Related Articles section for more information on these topics.

 

Downloadable Excel Examples of Shopify Product Listings
The file at the bottom of this article contains examples of products ready to list on Shopify. You can also use the file as a template.

 

What we'll cover:

  1. Adding Products to Inventory Before You List to Shopify
  2. Key Fields for Listing Products
  3. Creating Variation Listings
  4. Uploading Your Spreadsheet
  5. Related Articles
  6. Downloadable Excel Examples of Shopify Product Listings

 

Adding Products to Inventory Before You List to Shopify

This article assumes you already created your products in Solid Commerce and added them to inventory.

  • To learn how to create new products and add them to a Warehouse, see the Related Articles section.

 

Key Fields for Listing Products

Required Fields
Field Descriptions and Valid Values
results Leave this field blank. When you upload a file using the Solid Commerce Excel Add-In Tool, results will appear as the file processes.
product custom sku The SKUs of your products.
warehouse id The Warehouse IDs of your products.
product attribute:shopify product_type

The product_type field tags products on Shopify, which helps buyers find the products they are searching for. Separate each product type by a comma.

People usually use this field to categorize their products with an automatic collection. Collections are how Shopify implements categories. Learn more in Shopify's Manual.

mystore sell price exp

Controls the price of your item on your Shopify listing.

Enter a number without a currency symbol, or enter simple formulas with the word cost, such as cost*1.5 or cost+7. More complex formulas like cost*1.2+5 or ((cost*1.2)+5) work as well.

market auto rule

Determines how we should set prices on new listings, or update prices on existing listings.

Enter the name of the rule you want to use.

mystore qty exp

Enter lq in this field if you want to make your entire inventory available on Shopify. You can also enter formulas. See Using the Listing Quantity Expression to Control the Quantities on Your Listings for details.

list name The name of your My Store Market List in Solid Commerce.
po sources

The name of the Warehouse(s) Solid Commerce should use as the inventory source for your listings.

run mystore

Enter Yes to turn the automation on. We will automatically push your data to Shopify to list your product. If you enter No, your product will not list until you turn the automation on.

 

The following table includes two optional fields.

To see a complete list of fields, see Optional Shopify Fields Supported by Solid Commerce.

Key Optional Fields
Field Descriptions
product name
Copying your Product Names and pasting them into the Shopify tab of your spreadsheet is not required. However, the names can be handy as reference.
mystore title
If you want the title on your Shopify listing to be different than the Product Name in Solid Commerce, enter your unique titles into this field.

 

Creating Variation Listings

This section assumes you are familiar with listing variations directly on Shopify. If not, we recommend creating some variation listings in your webstore before pushing them from Solid Commerce.

Shopify variations are similar to eBay variations in many ways. Just like with eBay, you need to create parent and child products in Solid Commerce, and assign variation attributes to them. Our article Listing Variations on eBay will help you create your products.

EXAMPLES: The downloadable template at the bottom of this article contains examples of two variation listings.

To create a variation listing:

1) Create your parent and child products and add them to inventory.

2) In addition to your other Shopify data, provide the following variation information.

Variation Fields
Field Descriptions and Valid Values
mystore parent sku
The Parent SKU ties the all of the variation items together into one listing. Assign the Parent SKU to every item in the variation.
mystore options template

Enter the names of the Product Attributes you're including as options on your variation listing. Separate each attribute name by a double colon (::). You can include up to three options on one listing.

You only are only required to enter the option template name for the parent item. However, populating the option template name for your child items too is fine.

EXAMPLE: You have a t-shirt that is available in three sizes and two colors. You want to include all the options in one listing. If your Solid Commerce Product Attributes are: Size and Color. Your mystore options template will be: Size::Color.

If you want to list the t-shirts as size only variations, with each color listed separately, your mystore options template will simply be: Size.

product attribute:shopify position (optional)

This optional field sets the order of the child items in the drop-down menu. Enter 1 for the topmost item, 2 for the next item down, and so on.

 

3) Upload your file following the instructions in the Uploading Your Spreadsheet section below.

 

Uploading Your Spreadsheet

We recommend including the Shopify 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 Shopify tab of the file using our Excel Add-In Tool, click the Upload Data button. Check only the Update Marketplace box.

rakuten_integration_excel_marketplace_update.png

 

To upload the Shopify tab through our web uploader instead, go to the Products menu -> Import Products and Inventory. Check the Import Marketplace box and select MyStore from the Select marketplace drop-down.

newegg_integration_listing_web_uploader_settings.png

 

If you include Shopify Product Attributes (or any other Product Level fields) with your Shopify 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 Shopify.

For more detailed instructions on uploading files, see Uploading Spreadsheets With the Excel Tool and Web Uploader (pending).

 

Related Articles

 

Back to top

Downloadable Excel Examples of Shopify Product Listings

This file contains three sample listings: one single product, and two variations. You can also use the file as a template for creating new listings.

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

Comments

0 comments

Please sign in to leave a comment.