[3PL] Download details for ENTIRE inventory?

Raj · May 19, 2023, 3:15pm

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!

Rayanp · May 19, 2023, 3:47pm

Hey @Raj ,

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

Best,
RayanP

Rayanp · May 19, 2023, 5:41pm

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.

Let me know if this works for you!

Best,
RayanP

Raj · May 19, 2023, 5:49pm

Thank you @Rayanp , 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?

Rayanp · May 19, 2023, 5:57pm

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:

.

Is this available to you?

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

Best,
RayanP

Raj · May 19, 2023, 6:05pm

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