Looking for somebody to program macros that will look at a product SKU and create Color And Size Child Skus based off the original SKU automatically. This would be created from completed inventory files with parent skus.
I sell and create decals, however because of the amount of hassle and time it would take to manually create variations for my designs, I just list them in a few different sizes as separate listings and require customers to email for color options. This is not ideal and I want to take my entire catalog and apply the exact same size and color options to all of my SKUS. This way I do not have multiple listings of the same design just with a different size. This is bad because it's confusing and it means I have to set up PPC campaigns for each design more than once.
Here is an example of how I currently list the decals. > https://www.amazon.com/Double-Middle-Finger-Sticker-Wide-Long/dp/B01H95UH8I/ref=sr_1_3?ie=UTF8&qid=1477174433&sr=8-3&keywords=double+middle+finger+hello+kitty
However as you can see here we have the same design listed more than once costing more money, confusion and reviews are not linked..
I need the listing to be more like this > https://www.amazon.com/dp/B01M1C6CK4
However with more size and color options.
I will provide the list of colors and sizes and again they will be identical options for all skus. Currently there are over 20000 designs listed on amazon but its really more like 4-5k different designs, they are just listed more then once in different sizes. The total goal right now is to convert what I have listed right now to variations and remove duplicates. Then I will be working on thousands of more skus that will need these child sku variations created as well.
Current SKU : FD-JDM1-001
I would need the variation rows in excel created similar to this format for the CHILD skus
This child sku variation would be BLACK and 6" in size
Color Option(Non Removable- OUTDOORS): White, White (Matte), Black, Black (Matte), Olympic Blue, Light Navy, Green, Lime Tree Green, Real Red, Burgundy, Hottest Pink, Middle Grey, Canary Yellow, Orange, Very Purple, Silver, Gold
Size Wide-Long: 6", 8", 10",12",14",16",18",22, 24",26", 28"
*Removable Indoor Color options is something we want to offer in the near future*