API Feeds

Retired Boards Appdev Authentication
1

Any advice on setting up Products & Stock API feeds.
I have a supplier which has an API-KEY for us, but need to know how to set up or if there is an app that automates it?

API is capable for both JSON & XML responses.

Thanks

2

You can use Stockeo app to sync products and stock from an API. The app supports both formats, JSON and XML. An API key usually needs to be passed as the Authorization header:

LukaszWiktor_0-1671219905515.png
LukaszWiktor_0-1671219905515.png681×313 14.4 KB

or as a URL query parameter:

LukaszWiktor_1-1671219951304.png
LukaszWiktor_1-1671219951304.png685×191 9.27 KB

This depends on your supplier’s API specification.

3

Hi Lukas,

Thanks for coming back to me. Yes your app does look like it would work for us. Can i please ask a few questions?

Are you able to upload image files with the sync? (image urls)

Are you able to set rules for pricing ? as our pricing will be different to suppliers on API

How do the synced products appear in back office? Are they the same as if they had been done manually?

Once synced can they be moved around the the website, as we will have different menu headings and the same product may appear in 2 different sections on the website?

Looking at the pricing structure, can you advise if the variants are classed per product, or would it be all its variants? So T Shirt with 5 colours - would this be 1 or 5 variants?

Many thanks and i look forward to your reponse

Thanks

4

Hi @24W ,

I’m happy to answer your questions.

Are you able to upload image files with the sync? (image urls)

Yes, Stockeo can add images to imported products. You just need to add the Image URL field in the Data Mapping section, and specify which XML element or JSON property contains the image URL.

Are you able to set rules for pricing ? as our pricing will be different to suppliers on API

Yes, you can write a Liquid expression to calculates prices according to your rules.

How do the synced products appear in back office? Are they the same as if they had been done manually?

The synced products appear in the Shopify admin the same as if they had been created manually.

Once synced can they be moved around the the website, as we will have different menu headings and the same product may appear in 2 different sections on the website?

You can use collections to organize the imported products on your website. One product may appear in many collections. You most likely will want to use automated collections. Stockeo can add tags to the imported products. You can then create collections based on product tags.

Looking at the pricing structure, can you advise if the variants are classed per product, or would it be all its variants? So T Shirt with 5 colours - would this be 1 or 5 variants?

I’ve just released a possibility to group multiple variants into a single product. A T-shirt with 5 colours can be one product with 5 variants. To achieve this, you need to add a Variant Group - a field that has the same value for all variants that you want to combine. You also need to add an Option 1 field that will hold the variant colour.

LukaszWiktor_0-1671457671081.png
LukaszWiktor_0-1671457671081.png677×164 19.1 KB

5

Thats fab, thanks so much for your quick response.

Last question - to group the multiple variants, would this be done in the app before the API was downloaded?

6

Stockeo downloads the product data from the API first. The grouping of variants happens on the fly, when creating new products. The app checks by SKU if the products/variants downloaded from the API already exist in your store. Currently Stockeo can only group variants in new products. The app can’t attach a new variant to an existing product, at least not yet. Will this be a problem?

7

Hi Lukas,

I have downloaded the app and have encountered an issue, i have left a support request via the app 2 days ago, but no one is getting back to me? Are you able to chase up my request please?

Thanks

Stephanie

8

Any updates on importing new variants to existing products?

I have a JSON feed acting as middleware between my shop and supplier. It has unique identifiers for both the variant group (for example tshirt) and the variants (for example tshirt_blue_sm, tshirt_white_sm and tshirt_white_md together with variant attributes for each, i.e. size and color in this case) but we are unable to add new variants to existing products if our supplier adds new variants, for example yellow tshirts in sizes XS/SM.

Any workarounds for this scenario? Having two schedules (one for create and one for update) seems to create duplicate products for new variants even tho the variant group is the same for both products.