How to Create a Live Inventory Feed from Shopify

f you have a Shopfy store that you would like Spark Shipping to connect to for live inventory it can be done by doing the following.

Create a CSV Template

1. In the Shopfiy Admin go to Online Store -> Themes 

   

2. On your current theme go to ... -> Edit HTML/CSS 

   

3. Select 'Add a new Template' 

4. Create a new template for 'Collection' called 'csv' 

   

5. Replace the code in collection.csv.liquid with:

   {% layout none %}

   {% paginate collection.products by settings.collection_ppp %}

   {% endpaginate%}

    

   SKU, Quantity, Cost, Product Name<br/>

   {% for product in collection.products %}

     {% for variant in product.variants %} 

       {{variant.id}}, {{variant.inventory_quantity}}, {{variant.price}}, {{product.title}} ({{variant.title}})<br/>

     {% endfor %}

   {% endfor %}

Create a Collection of all the Products

1. Go to Products -> Collections -> Add A New

   

    
2. Title = All Products
3. Conditions -> Automatically select products based on conditions
4. Inventory Stock is greater than -1 

   

5. Template -> collection.csv 

   

6. Save Collection 

   

Use the Collection as a Spark Shipping Inventory Feed

1. Go to Products -> Collections -> All Product (click all products) -> View (top right)

   

    

2. That will take you to your inventory new feed! 

3. Copy this URL when setting up an inventory feed in Spark Shipping. 

4. When creating a new Inventory Update in Spark Shipping select the HTTP as the Inventory Method and use the URL from above as the HTTP URL