Fetch and store serial number from 3PL central

pooja_zakhariya
Tourist
11 0 2

Hello,

Is it possible to fetch and store serial number of product delivered to store in shopify?

One of our client is using 3PL central for fulfillment so we need to check feasibility whether shopify can store serial numbers or not?

 

 

Thanks,

0 Likes
Greg_Kujawa
Shopify Partner
965 80 204

Depending on how the Shopify products and their variants are defined, perhaps you could utilize the product variant's SKU property? This is a unique identifier. If they are already using this SKU property, you can utilize an option to define a custom field and its value. For example, if option1 isn't being used you could utilize 

"option1": "{the_sku_value}"

 

See here for details --> https://shopify.dev/docs/admin-api/rest/reference/products/product-variant?api[version]=2020-04

 

0 Likes
pooja_zakhariya
Tourist
11 0 2

HI,

Serials numbers will be unique for each quantity for e.g bike or laptops. It will have unique serial number for each unit delivered. So if I deliver 3 qty I need to enter 3 serial numbers for that product.

Thanks,

0 Likes
Greg_Kujawa
Shopify Partner
965 80 204

That would work then. As long as the products haven't already been defined with the maximum of three variant options you are fine.

 

It'd be like this crude mapping, assuming that Option1 hasn't already been used for something such as size, color, etc.  :)

Product => Men's 26" Beach Cruiser

     Variant => Option1 = 123456789

     Variant => Option1 = 987654321

     Variant => Option1 = 012345678

 

Of course depending on the scope and depth of your inventory it could result in a lot of variants. See https://help.shopify.com/en/manual/products/variants/add-variants#:~:text=You%20can%20create%20up%20... for details.

0 Likes
pooja_zakhariya
Tourist
11 0 2

HI,

This can result in n no of variants and this way we can not manage proper stock level and inventory valuation.

Thanks,

0 Likes
Greg_Kujawa
Shopify Partner
965 80 204

We ran into a similar challenge when evaluating Shopify. We have a lot (i.e. - over 75%) of our inventory as serialized. Since we need to report back on vendor consignment activity for reconciling things. In terms of report analysis and stock levels, we just roll up all "child" variants to the "parent" product level. This is usually done outside of canned Shopify reports, since using the API we can extract the data and slice/dice however we'd like.

0 Likes