Q: Why does Product CSV export NOT include product ID?

Highlighted
Shopify Expert
261 0 9

noticed that when you export CSV of products, the product ID is not included in the export. 

Is this just an oversight, or is there a reason for this?

thanks,

m

meeech | http://www.twitter.com/meeech | http://mitchell.amihod.com
0 Likes
Highlighted
Shopify Expert
4188 29 412

My 0.02 is that since products have a unique handle, and since a handle far more human friendly to glance at in a spreadsheet, it is not needed to dump ID's. After all, they are meaningless for the most part since the CSV import uses the handle to parse products and their variants. 

What would you use the ID for anyway?

Custom Shopify Apps built just for you! hunkybill@gmail.com http://www.resistorsoftware.com
0 Likes
Highlighted
Shopify Expert
261 0 9

well, one use

http://api.shopify.com/product.html#update

lots of API calls rely on product id. so if you are doing something where the client exports the .csv, makes some changes/customizations, and then write an app to ingest it, ID would be handy, yes?

 

meeech | http://www.twitter.com/meeech | http://mitchell.amihod.com
0 Likes
Highlighted
Shopify Expert
4188 29 412

If they go to the effort to export a CSV, fix it up, then they should probably just use import to digest it. 

If you have a case where the client needs to customize a product that goes beyond the CSV format provided by Shopify, use the API to write your own CSV for them to edit (your own dog food neh?), complete with ID, so that the App can then ingest your own dog food... per say...neh?

I have experienced much frustration over the years with the handle vs. ID issue.. both from the front and back end perspective... so I am somewhat in agreement with you that it should be consistent, whatever it is. Since you can use the API to Find resources by handle, it means you can indeed accept a CSV from a client and ingest it... right?

 

 

Custom Shopify Apps built just for you! hunkybill@gmail.com http://www.resistorsoftware.com
0 Likes
Highlighted
Shopify Expert
261 0 9

and then add yet another call against your 300 per 10 minutes limit, looking up the product id. 

Obviously, i can write something to generate a custom CSV with prod id, but it still seemed like an oversight to not include it. Handles can change, id's don't (or shouldn't). 

meeech | http://www.twitter.com/meeech | http://mitchell.amihod.com
0 Likes
Highlighted
Shopify Expert
4188 29 412

AFAIK you can always use the handle:

eg: 

 

p = ShopifyAPI::Product.find(:first, :params => {:handle => 'foomanchu'})
p.update
p.save!

So you have to get the resource to update, 1 call, and then one to save, 2 calls... getting the ID is not necessary... even if you had it, you still blow 2 calls to update a resource.

 

 

 

 

 

 

 

Custom Shopify Apps built just for you! hunkybill@gmail.com http://www.resistorsoftware.com
0 Likes
Highlighted
Shopify Expert
261 0 9

Don't see how you get 2 calls to update a resource. if I have the  id, its one call:

http://api.shopify.com/product.html#update

meeech | http://www.twitter.com/meeech | http://mitchell.amihod.com
0 Likes
Highlighted
Shopify Expert
4188 29 412

I use the gem. I never post raw JSON. There you go. I guess that is why you're stuck on the ID. 

 

Custom Shopify Apps built just for you! hunkybill@gmail.com http://www.resistorsoftware.com
0 Likes
Highlighted
Shopify Expert
261 0 9

I guess i like to peek behind the curtain. i'm not stuck on the ID. just wondering why its not included. obviously i can work around it. :P

meeech | http://www.twitter.com/meeech | http://mitchell.amihod.com
1 Like
Highlighted
Shopify Staff
Shopify Staff
5704 1 320

You guys are too much.

0 Likes