How do i make bulk update using specific field?

[Max]

Hi, is there anyone who has an idea to make bulk product update using
specific field? i mean for example i have 1000 product and every
product have images, description, sku, variant, price ..so on.....but
i want to uddate products twice a day using only product's sku and
qty... so i just can upload csv file have only two or three field...i
tried this with metafield app but that app is absolutely not for this
case.
thanks guys in advance...

[Dave]

If you have 1000 Products, and you want to update all of them, using the API, then you need to ask for all 1000 of your products. Since the API will give you them 250 at a time, that means 4 API calls. Since you are allowed 500 in 300 seconds, the 4 calls not stress the API too much. Once you get a block of 250 products you can update them one at time by looping through them and updating the field(s) you are interested in. 

There are probably a dozen simple patterns to apply here. For example, you could read in your own custom CSV and for each Product in your CSV, ask the API for the Product and update it. This would be terribly inefficient API wise as you'd do 1000 calls, but hey, calls are free so who cares right. 

You could ask Shopify for blocks of 250 at time, and then look inside the CSV file for matches. That way, you update up to 250 products with one API call, and a simple look through the CSV for the matches. 

So... rest assured, no matter how you slice it, your request is possible to do, pretty easily, with basic scripting and the API. If you want someone to set you up with all the code to do that, just ask. I am sure there are plenty of coders that would take the time to script you a solution.

[Alexandre Saiz Verdaguer]

Take a look at fastprice app. (already on the appstore). This app is for product price updates but I'm sure we could tweak it in order to help you update stock and sku/eans.

Alexandre Saiz

+34 659 07 85 44

+1 801 696 4222 (USA)

skype: alexandre.saiz

Shopfrogs s.l.

--
 
 
 

[Max]

Thanks Dave

have one more question..

i am trying to use  "curl" and private app API and have successed to access to my shop but got an error message to modify current product using 'curl' in php below is the code how i used plz correct me... thanks....(i put xml file as input.xml which included modify detail and tried sku using product i.d)

and also is there any where keep modifying more than 250 product on one click? 

//php

curl -v -X PUT -d @input.xml -H 'Content-Type: application/xml' 'https://apikey:password@myshopdomain/admin/products/producti.d.xml'

//

[Max]

Hi thanks  Alexandre 

all i need is to make bulk update sku, qty, price, compare at price at once how we do this plz let me know im desperate.....