[3PL] Download details for ENTIRE inventory?

GraphQL API
1

Hi, What’s the most efficient way to regularly (ideally once daily) download few important details per sku of entire 3PL inventory? (50K+ SKUs and growing)

  • SKU
  • id
  • Name
  • Barcode
  • Client ID/Alias

Snapshots only give me SKU and Qty.

Thank you!

2

Hey @Raj ,

Thanks for reaching out!
Looking into this now, I’ll have an update for you shortly.

Best,
RayanP

1 Like
3

Hey @Raj,

Thanks for hanging in there!

In the products page https://app.shiphero.com/dashboard/products, you can export all rows of products or you can filter the column visibility and download products 1000 at a time via CSV or PDF.
image

Let me know if this works for you!

Best,
RayanP

4

Thank you @sh-agent , but a very important field ‘barcode’ is missing in that export.

Also, 10K per download isn’t ideal, but that’s the secondary problem. Any suggestions to get barcode too?

5

Hey @Raj.

Thanks for the quick reply.

When I click on column visibility in the top right, I’m able to see a dropdown to filter the the table like this:

image
image370×1564 67.1 KB
.

Is this available to you?

Please let me know if you have any questions or concerns.

Best,
RayanP

1 Like
6

Dammit I totally missed that… well, kinda lol - so if I go by 10K download per file, then I can get barcode, but if I click on ‘Export All Rows’ then it’s just the standard set of columns. So close!!

Btw I was way off - we don’t have 50K+ skus, but 96K+ skus :smiling_face_with_tear:

1 Like