How can I assign multiple SKUs to a single variant in my online bike store?

[BrickellBikes]

Hi 

I've looked around but I haven't been able to find a solution. We have a bicycle store and we sell bikes online. Now every bicycle has its own serial number we need to track.

I.e. We have 10 bikes at size small each one has its own serial number right, now I can only put one serial number to the 10 bikes available listed online. I would like to list all 10 serial numbers so that when we sell one the we know which bike sold to any specific person. So when my employees go and get the bike that sold online they know which one to grab and we keep track. 

I would like to know if there's a way or an app that will allow me to list all 10 sku to a variant.

Thanks 

[LaunchTip]

An interesting setup for sure!

Instantly I think licensing. You can get apps which issue a license upon sale and can insert this into Order notes etc.

So for Bike - Style 1. Let's say you have 10 serials (10 in stock), you could load up 10 licenses to this sku and it would assign it upon sale.

Something like this may be a solution.

[TeamSpocket]

@BrickellBikes,

The purpose of the SKU is to track the product being sold down to the model/variant.  If you wish to track each of your products, you will need to implement a serialized inventory.  You can use this to track individual units using unique serial numbers.  This is usually done using an inventory management system (outside Shopify). 

You can check these services:

https://www.skulabs.com/serialized-inventory-management

https://clearspider.net/features/serialized-inventory/

I hope this helps. By the way, are you looking for high-quality products for your dropshipping store? You Should try Spocket. It's a dropshipping app that allows you to sell high-quality products from our suppliers located around the world. We have suppliers based in major countries like the US, UK, Canada, and Australia.

You can sign up for a free Spocket account and browse our catalogs of products. We also provide a 14-day free trial on our paid subscription to help you get started with selling. You can also check our success stories on some of our retailers.

[Galmis]

Hi @BrickellBikes,

Would it be acceptable if your employees picked any bike of the same model and added its serial number to the order line item while picking the bike? If that's the case, you may want to try Serializer - Product Tracking. 

With the app, you can

• Associate serial numbers with order line items. You can type in the numbers manually or scan them using a mobile device's camera or a barcode scanner.
• Quickly search the item by its serial number and pull up the customer and order information.
• Track item's warranty.

[averyjoelle]

Did you ever figure out a solution for this?