I'd like to present an idea aimed at addressing the challenges associated with CSV uploads, drawing inspiration from my prior experience with StitchLabs, a system that was highly efficient in managing inventory. StitchLabs had a feature that greatly simplified tasks like updating product information and creating bundles using CSV files.
Here's how it worked: Every item added to the system was assigned a unique variant ID, which users could not modify. These variant IDs played a crucial role in identifying and tracking each newly created variant. The introduction of this concept, the variant ID, made it significantly easier for users to make changes to product titles, SKUs, and other relevant information. As long as the variant ID remained unchanged, the system could accurately associate all edits with that specific product or variant.
Furthermore, this functionality was extended to creating bundles using CSV files. To specify which components would constitute a particular bundle, users simply assigned the variant IDs of each bundle component, along with the quantity, by separating the amount with a comma under the "Bundle Component" column.
Here's an example of how this system was structured for creating a bundle and its corresponding components with variant IDs:
Variant ID (Reference Only) SKU Bundle Components
The Variant ID was what Stitchlabs recognized as the product/variant, and the user simply used the SKU for their reference. In the example below, the bundle SKU ARTK097-G_AR002-6-12 would consist of one each of SKU ARTK097-G and AR002-6-12.
|Variant ID (Reference Only)||SKU||Bundle Components|
Under the "Bundle Components" column, the user would input the variant IDs corresponding to each SKU that would make up the bundle (4444 = AR002-6-12) and (5555 = ARTK097-G). The "1" following the comma after the variant IDs represented the quantity of each component that would make up the bundle.
I believe that implementing a similar approach in our CSV upload system could significantly enhance the user experience and streamline product and bundle management.