Migrations

  1. Home
  2. Support
  3. Migrations
  4. Shopify to Avoori – Migrate and Export/Import Products For Large Stores – Over 50 Products

Shopify to Avoori – Migrate and Export/Import Products For Large Stores – Over 50 Products

To move your Shopify products to an Avoori Online Store, and your store has a large number of products, this guide is for you. If you have a small store, with under 50 products, please refer to our other Shopify migration article: Shopify to Avoori – Migrate and Export/Import Products For Small Stores – Under 50 Products.

This is a more advanced migration option that uploads your images automatically to the media library and also allows you to have product variations.

You can use this migration option by exporting a CVS file from Shopify and uploading it in Avoori, using the Advanced Product Import option available from the Online Store > Settings > Advanced Import menu.

Image required here: Advanced product import screen.

The CVS file should be created with the following column headers:

COLUMN DESCRIPTION VALUES EXAMPLE
tax:product_type Required. Say if the product is Simple, Grouped, External, or Variable. simple / variable / grouped / external simple
post_type By default, this is product. product product
menu_order Sort your products. Numerical 8
post_status Choose if your post should be published or not. draft / publish / pending / private publish
post_title Required. Name of the product. Text White Mirror
post_date Choose the date you wish for your product mm/dd/yyyy

dd-mm-yyyy

02/09/2019

22-09-2019

post_content A description of the product. Text Super reflecting white mirror.
post_excerpt Short description of the product. Text Latest mirror.
post_parent Put the ID of the parent product. Post ID 278
post_password Create a password if you want to make the product private. Text !MyPassword!
visibility Choose visibility for your product. visible / catalog / search / hidden visible
sku SKU of the product. Must be unique. Text SK75676
upsell_skus SKU(s) of the product. Text – skus separated by “|”. SKU1|SKU2
upsell_ids ID of the product to upsell. post ID – IDs separated by “|” . 167|898
crosssell_skus SKU(s) of cross-selling products. Text – skus separated by “|”. SKU1|SKU2
crosssell_ids ID of the cross-selling  products. post ID – IDs separated by “|”. 978|266
featured Choose to feature. yes/no yes
downloadable Choose to download. yes/no yes
virtual Pick if virtual product. yes/no yes
regular_price Normal price of your product. Decimal number 9.99
sale_price Sale price. Decimal number 6.99
manage_stock Pick if you manage stock. yes/no no
stock The number of items in stock. Numerical 6
stock_status Choose if you have stock. instock / outofstock instock
backorders Whether you’re accepting backorders. yes/no/ notify yes
weight The weight of your product. Numerical 2.43
length Length of your product. Numerical 13
width Width of your product. Numerical 20
height Height of product. Numerical 8
tax_status Product is or not taxable. taxable / shipping / none taxable
tax_class Tax class of your product. zero-rate, reduced-rate

Blank for Standard Rate.

tax:product_shipping_class Product’s shipping class Set the Shipping Class. Class 1
sale_price_dates_from Start date of sale price. MM DD YYYY 11/22/2019
sale_price_dates_to End date of sale price. MM DD YYYY 08/22/2019
images Import images. Use a pipe to separate multiple images.

Enter the image URL or file name.

Text image1.jpg | image2.jpg | image3.jpg
product_url Use for External/Affiliate products sold on another website. URL http://amazon.com/etc
button_text Text on your “Add to cart” button. Used by External/Affiliate products only. Text Buy now
meta:_sold_individually Choose if the product can only be sold on its own yes/no yes
meta:total_sales Total sales. Numerical 78

 

Upload images directly to the media library.

For this option, you can include external URL links with the product images in your CVS file. This will allow for the images to be automatically saved to the media library when you import your CSV file.

Import product variations.

After importing your products you can import product variations, by creating a separate CVS file for the variations.

You must include a column with the ID or SKU of the parent products so that the importer knows which product your item is a variation of.

COLUMN DESCRIPTION VALUES EXAMPLE
post_parent Parent product of the variation: that product’s ID. numerical 465
parent_sku Parent product of the variation: that product’s SKU. text SK68575

 

Additionally, you can add these columns with your variations.

COLUMN DESCRIPTION VALUES EXAMPLE
post_status Post status of variation. draft / publish / pending / private draft
sku Recommended. Unique SKU of the variation. Text SH99786
downloadable Downloadable item or not. yes/no no
virtual Pick if virtual product. yes/no yes
regular_price Required for all variations.

Normal price of your variation.

Decimal number 29.99
sale_price Sale price of your variation, if it’s on sale. Decimal number 18.99
stock Number of this item’s variation you have in stock. Numerical 7
weight Weight of your variation. Numerical 2.5
length Length of your variation. Numerical 13
width Width of your variation. Numerical 23
height Height of your variation. Numerical 7
tax_status Whether your variation is taxable or not. taxable/ shipping/none taxable

 

Now that you have your variation CVS file, choose the option to Import Variations and upload it. Just like with the parent products, you need to map the fields.

Image required here: Product variations import screen.

Finally, click on Submit and check how the variations are now looking on your website!

Something missing? Contact us
Was this article helpful to you? Yes No

How can we help?