Struggling with Variants within my data

Mr Young

New Member
Joined
Jul 8, 2022
Messages
3
Office Version
  1. 365
Platform
  1. MacOS
Hello. Hope you're all well. I desperately need some help with a csv file I need to create to upload products onto shopify please. I've got 22 000 lines of data to work through and although I'm using a lot of formulas to get the format right, I'm struggling with the last bit and it seems the most difficult of all.
The aim of the game is to sort through the 22 000 lines of data, in order to create a new list which contains maybe 10 000 products with TAGS. This part I've done. (The other 12 000 lines are additional images).
Now I need to merge these products together in such a way that I have maybe 1000 products to upload onto Shopify with lets say 5 variants each, which each have a further 2 variants. This is soul destroying, taking me forever. I'm beginning to become quite the expert when it comes to adult sex toys but I digress.

I think there are three two different ways this could be done but I'm not sure if it would work:

1. Ideally I would have liked to use a formula to group "Almost duplicates" together using the TITLE column. I'd have to do this Vendor by Vendor though as you cant group 2 products together from 2 different vendors. This is not too difficult but like I said, very time consuming.

2. If I were able to open the url images as thumbnails in the adjacent column I could then sort by image but this too will take forever.

3. Im hoping a few formulas can do the bulk of the work and all I would have to do is check each new product and its variants which is actually not that difficult.

Here is what needs to happen:
1. Assign a tag using TITLE and formula =TEXTJOIN(", ", TRUE, IF(COUNTIF(B2, "*"&$BN$2:$BN$150&"*"), $BN$2:$BN$150, ""))
2. Then extract the TAGS from the TITLE
3. Combine VENDOR and TAG to create HANDLE

4. The remaining words (TITLE minus TAGS) becomes the variant and is moved to OPTION0 VALUE
5. OPTION1 NAME is auto populated based on OPTION1 VALUE ie. STYLE or COLOUR or SIZE
6. It gets messy now as there's usually already values in OPTION1, OPTION2 and OPTION3, I tend to look at them for colours and sizes.

7. Data now gets sorted via HANDLE to create my new product names. These new product names, also referred to as Almost Duplicates
8. Now I need to merge the descriptions of each product within BODY (HTML) into the description on line 1 of each product (not variant) and add headings for each variant within the description using <h4>Option1 Value</h4>
9. Last but not least, clear all the data thats not needed and viola.

Easier said then done. There has got to be be a way to do this. I've got this sheet to finish and have already been given the next sheet with its 67 000 lines of data.

I've created 2 mini-sheets which hopefully would make a lot more sense than my rambling. Before and After data.

Any help would really be appreciated.

Thank you

Zander

Example Workbooks.csv
ABCDEFGHIJKLMN
1Variant SKUVendorTitleBodyTagsOption1 NameOption1 ValueOption2 NameOption2 ValueVariant BarcodeImage SrcImage PositionVariant ImageVariant Price
2BAD2031-QBaci LingerieBaci - Lace Garter Look Stockings - CurvySexy lace garter look stockings with a beautiful stretchy curve-friendly fit. These stockings pair well with other lingerie.StockingsSizeQueen Size (46 - 52)ColourBlack4890808183205http://cdn.edc.nl/800/BAD2031-Q.jpg112.99
3BAD 2032.00Baci LingerieBaci - Sheer Garter Look Stockings - BlackSexy sheer garter look stockings with a beautiful stretchy fit. These stockings have a wide lace waste band. These stockings pair well with other lingerie.StockingsSizeOne SizeColourBlack4890808183212http://cdn.edc.nl/800/BAD2032.jpg114.99
4BAD2032-QBaci LingerieBaci - Sheer Garter Look Stockings - CurvySexy sheer garter-look stockings with a beautiful stretchy curve-friendly fit. These stockings have a wide lace waste band. These stockings pair well with other lingerie.StockingsSizeQueen Size (46 - 52)ColourBlack4890808183229http://cdn.edc.nl/800/BAD2032-Q.jpg114.99
5BAD 2033.00Baci LingerieBaci - Sexy Seamed Stockings - BlackSexy black sheer seamed thigh highs Stretchy material. These stockings don't have stay-up support. Combine them with a garter belt and a pair of beautiful high heels.StockingsSizeOne Size (S-L 34 - 40)ColourBlack4890808183236http://cdn.edc.nl/800/BAD2033.jpg19.99
6BAD2033-QBaci LingerieBaci - Sexy Seamed Stockings - CurvySexy black sheer seamed stockings with a cut for curves. The material is soft and stretchy. These stockings don't have stay-up support. Combine them with a garter belt and a pair of beautiful high heels.StockingsSizeQueen Size (46 - 52)ColourBlack4890808183243http://cdn.edc.nl/800/BAD2033-Q.jpg19.99
7BAD 2034.00Baci LingerieBaci - Sexy Seamed Stockings - NudeSexy, stretchy, thigh highs with black seam. Sheer, beige stockings. Combine them with a garter belt and a pair of beautiful high heels.StockingsSizeOne Size (S-L 34 - 40)ColourBeige4890808183250http://cdn.edc.nl/800/BAD2034.jpg19.99
8BAD2034-QBaci LingerieBaci - Sexy Stockings with a Seam - CurvySexy nude sheer seamed stockings cut for curves. Stretchy material. These stockings don't have stay-up support. Combine them with a garter belt and a pair of beautiful high heels.StockingsSizeQueen Size (46 - 52)ColourBeige4890808183267http://cdn.edc.nl/800/BAD2034-Q.jpg19.99
9BAD 2036.00Baci LingerieBaci - Stay Up Seamed Stockings - BlackSexy black seamed stockings. These stockings have built in silicone stay-ups around the top, so you can wear them without a garter belt. These stretchy stockings are beautifully designed.StockingsSizeOne SizeColourBlack4890808183298http://cdn.edc.nl/800/BAD2036.jpg112.99
10BAD2036-QBaci LingerieBaci - Sheer Stay Up Seamed Stockings - CurvySexy black seamed thigh highs These stockings have built in silicone stay-ups around the top, so you can wear them without a garter belt. These stretchy stockings are cut for curves.StockingsSizeQueen Size (46 - 52)ColourBlack4890808183304http://cdn.edc.nl/800/BAD2036-Q.jpg112.99
11BAD 2037.00Baci LingerieBaci - Sheer Stay Up Stockings With Strap - BlackSexy, black, high stay-up stockings. These stockings have built-in silicone stay-ups around the top, so you can wear them without a garter belt. These stretchy stockings are beautifully designed.StockingsSizeOne SizeColourBlack4890808183311http://cdn.edc.nl/800/BAD2037.jpg114.99
12BAD2037-QBaci LingerieBaci - Silicone Stay-Up Stockings - CurvyThese stylish queen-size stockings, will enticingly accentuate your legs. These stockings are detailed with a wide and striped edge. When wearing, the silicone edge perfectly keeps them up without garters. They are designed for curves.StockingsSizeQueen Size (46 - 52)ColourBlack4890808183328http://cdn.edc.nl/800/BAD2037-Q.jpg114.99
13BAD 2038.00Baci LingerieBaci - Sheer Garter Stockings With Polkadot Print - BlackFeel sexy in these beautiful, sheer garter stockings. The stockings have a playful polkadot print and are stretchy for a nice fit. Combine the stockings with a garter belt and a pair of beautiful high heels.StockingsSizeOne SizeColourBlack4890808183335http://cdn.edc.nl/800/BAD2038.jpg114.99
14BLD1260Baci LingerieBaci - Sexy School Girl Costume With TieSeduce your partner and entice each other's fantasy with this School Girl Costume! Particularly suited for exciting role-play. The costume includes of a nicely fitted black top with a removable tie. The matching wide skirt has a lace ruffle at the bottom. Stretchy material, which makes for a beautiful fit.School GirlSizeOne SizeColourVarious colours4890808123171http://cdn.edc.nl/800/BLD1260.jpg129.99
15Baci Lingeriehttp://cdn.edc.nl/800/BLD1260_2.jpg2
16BLD1265Baci LingerieBaci - Naughty School Girl CostumeSeduce your partner and entice each other's fantasy with this School Girl Costume! Particularly suited for exciting role-play. The costume includes a beautifully fitted sheer top with a collar and short sleeves. You tie the top at the front. The matching wide skirt has a lace ruffle at the bottom. The material is stretchy, which makes for a nice fit.School GirlSizeOne SizeColourVarious colours4890808123225http://cdn.edc.nl/800/BLD1265.jpg129.99
17Baci Lingeriehttp://cdn.edc.nl/800/BLD1265_2.jpg2
18BLD1266Baci LingerieBaci - 2-Piece School Girl CostumeSeduce your partner and entice each-other's fantasy with this School Girl Costume! Particularly suited for exciting role-play. The costume includes a beautifully fitted top and a matching wide-fitting checkered skirt. The top has a halter neck and a playful bow. The material is stretchy, which makes for a nice fit.School GirlSizeOne SizeColourBlack4890808123232http://cdn.edc.nl/800/BLD1266.jpg127.99
19Baci Lingeriehttp://cdn.edc.nl/800/BLD1266_2.jpg2
20BLD1267Baci LingerieBaci - 2 Piece School Girl Costume - Black / RedSeduce your partner and entice each other's fantasy with this School Girl Costume! Particularly suited for exciting role-play. The costume includes a beautifully fitted top and a matching wide-fitting checkered skirt. The top has a halter neck and a playful bow. Stretchy material, which makes for a beautiful fit.School GirlSizeOne SizeColourVarious colours4890808123249http://cdn.edc.nl/800/BLD1267.jpg127.99
21Baci Lingeriehttp://cdn.edc.nl/800/BLD1267_2.jpg2
22BLD1270Baci LingerieBaci - Boarding School Girl CostumeSeduce your partner and entice each other's fantasy with this Boarding School Girl Costume! Particularly suited for exciting role-play. The costume includes a beautifully fitted top with collar and short sleeves. You tie the top at the front. The matching wide pleated skirt completes this look. Stretchy material, which makes for a beautiful fit.School GirlSizeS/MColourVarious colours4890808123324http://cdn.edc.nl/800/BLD1270.jpg129.99
23Baci Lingeriehttp://cdn.edc.nl/800/BLD1270_2.jpg2
24BLD1271Baci LingerieBaci - Studious School Girl CostumeSeduce your partner and entice each other's fantasy with this Studious School Girl Costume! Particularly suited for exciting role-play. The costume includes a beautifully fitted top with collar and short sleeves. You tie the top at the front. The matching wide pleated skirt completes this look. Stretchy material, which makes for a beautiful fit.School GirlSizeOne SizeColourVarious colours4890808123355http://cdn.edc.nl/800/BLD1271.jpg129.99
25Baci Lingeriehttp://cdn.edc.nl/800/BLD1271_2.jpg2
26BLD1275Baci LingerieBaci - Sweet School Girl CostumeSeduce your partner and entice each other's fantasy with this School Girl Costume! Particularly suited for exciting role-play. The costume includes a beautifully fitted sheer top with a collar and short sleeves. You tie the top at the front. The matching checkered skirt is wide and short and completes the look. Stretchy material, which makes for a beautiful fit.School GirlSizeOne SizeColourVarious colours4890808123393http://cdn.edc.nl/800/BLD1275.jpg129.99
27Baci Lingeriehttp://cdn.edc.nl/800/BLD1275_2.jpg2
28BLD1276Baci LingerieBaci - Sexy School Girl CostumeSeduce your partner and spark each other's fantasies with this School Girl Costume! It's perfect for exciting role-play. The costume includes a gorgeous fitted top with a collar and short sleeves. The top ties at the front. The matching wide skirt has a lace ruffle at the bottom. Stretchy material, which makes for a beautiful fit.School GirlSizeOne SizeColourVarious colours4890808123409http://cdn.edc.nl/800/BLD1276.jpg132.99
29Baci Lingeriehttp://cdn.edc.nl/800/BLD1276_2.jpg2
30BLW3106-BLKBaci LingerieBaci - Strappy Open Cup Bra SetSeduce your partner with this revealing bra set. This set features a playful polka dot print, open cups and adjustable bra straps. The stretchy material makes for a great fit.bra setSizeOne Size (S-L 34 - 40)ColourBlack4890808166109http://cdn.edc.nl/800/BLW3106-BLK.jpg119.99
31Baci Lingeriehttp://cdn.edc.nl/800/BLW3106-BLK_2.jpg2
32BLW3106-REDBaci LingerieBaci - Strappy Open Cup Bra Set - RedFeel sexy and confident in this beautiful 2-piece set. This bra set has open cups, underwire support and adjustable straps. The matching, eye-catching thong completes the look. The stretchy material makes for a great fit.bra setSizeOne SizeColourRed4890808166116http://cdn.edc.nl/800/BLW3106-RED.jpg119.99
33Baci Lingeriehttp://cdn.edc.nl/800/BLW3106-RED_2.jpg2
34BLW3124Baci LingerieBaci - Lace Corset Look CatsuitFeel sexy and confident in this eye-catching lace catsuit. This corset-look catsuit is made from tretchy material for a beautiful fit.catsuitSizeOne Size (S-L 34 - 40)ColourBlack4890808176412http://cdn.edc.nl/800/BLW3124.jpg119.99
35Baci Lingeriehttp://cdn.edc.nl/800/BLW3124_2.jpg2
36BLW3124-QBaci LingerieBaci - Lace Garter Catsuit - CurvyFeel sexy and confident in this eye-catching lace garter catsuit. The catsuit has attached garters and is completely see-through. The catsuit is made of stretchy material and is cut for curves.catsuitSizeQueen Size (46 - 52)ColourBlack4890808176429http://cdn.edc.nl/800/BLW3124-Q.jpg122.99
37Baci Lingeriehttp://cdn.edc.nl/800/BLW3124-Q_2.jpg2
38BLW3125Baci LingerieBaci - Fishnet Garter Catsuit - BlackFeel sexy and confident in this eye-catching garter catsuit. The catsuit has attached garters and is completely see-through. The elastic material makes for a nice fit.catsuitSizeOne SizeColourBlack4890808176450http://cdn.edc.nl/800/BLW3125.jpg114.99
39Baci Lingeriehttp://cdn.edc.nl/800/BLW3125_2.jpg2
40BLW3125-QBaci LingerieBaci - Fishnet Garter Catsuit - CurvyFeel sexy and confident in this eye-catching garter catsuit. The catsuit has attached garters and stockings and is completely see-through. Stretchy material, which makes for a beautiful fit.catsuitSizeQueen Size (46 - 52)ColourBlack4890808176467http://cdn.edc.nl/800/BLW3125-Q.jpg117.99
41Baci Lingeriehttp://cdn.edc.nl/800/BLW3125-Q_2.jpg2
42BLW5000Baci LingerieBaci - Sexy Open Cup CatsuitYou will feel sexy in this striking, crotchless catsuit with sheer cups. This garter-look catsuit features a playful flower print. The stretchy material makes for a great fit.catsuitSizeOne Size (S-L 34 - 40)ColourBlack4890808200179http://cdn.edc.nl/800/BLW5000.jpg117.99
43Baci Lingeriehttp://cdn.edc.nl/800/BLW5000_2.jpg2
44BLW5000-QBaci LingerieBaci -Crotchless Garter-Look Catsuit - CurvyYou will feel sexy in this striking, crotchless catsuit with sheer cups. This catsuit is designed for curves and made from stretchy material for a beautiful fit.catsuitSizeQueen Size (46 - 52)ColourBlack4890808200186http://cdn.edc.nl/800/BLW5000-Q.jpg119.99
45Baci Lingeriehttp://cdn.edc.nl/800/BLW5000-Q_2.jpg2
46BLW5001Baci LingerieBaci - Sexy Long-Sleeved Crotchless Fishnet CatsuitFeel sexy and confident in this beautiful long-sleeved fishnet catsuit. This crotchless catsuit is made from stretchy material for a beautiful fit.catsuitSizeOne SizeColourBlack4890808200193http://cdn.edc.nl/800/BLW5001.jpg119.99
47Baci Lingeriehttp://cdn.edc.nl/800/BLW5001_2.jpg2
48BLW5001-QBaci LingerieBaci - Long-Sleeved Lace Garter Catsuit - CurvyFeel sexy and confident in this eye-catching fishnet garter catsuit. The catsuit has long sleeves and attached garters. The catsuit is made of stretchy material and is cut for curves.catsuitSizeQueen Size (46 - 52)ColourBlack4890808200209http://cdn.edc.nl/800/BLW5001-Q.jpg122.99
49Baci Lingeriehttp://cdn.edc.nl/800/BLW5001-Q_2.jpg2
50BLW5003Baci LingerieBaci - One Shoulder CatsuitYou will feel sexy in this striking, one-shoulder catsuit. This striking catsuit is completely transparent and features revealing sides. The stretchy material makes for a great fit.catsuitSizeOne Size (S-L 34 - 40)ColourBlack4890808200230http://cdn.edc.nl/800/BLW5003.jpg117.99
51Baci Lingeriehttp://cdn.edc.nl/800/BLW5003_2.jpg2
52BLW5003-QBaci LingerieBaci - One Shoulder Crotchless Fishnet Catsuit - CurvyFeel sexy and confident in this one-shoulder fishnet catsuit. This crotchless catsuit has striking details. Curve-friendly design and stretchy material.catsuitSizeQueen Size (46 - 52)ColourBlack4890808200247http://cdn.edc.nl/800/BLW5003-Q.jpg119.99
53Baci Lingeriehttp://cdn.edc.nl/800/BLW5003-Q_2.jpg2
54BLW5005-QBaci LingerieBaci - Sexy Catsuit With Revealing Sides - CurvyFeel sexy and confident in this fishnet catsuit with revealing sides. The catsuit has a stretchy, curve-friendly fit and is crotchless.catsuitSizeQueen Size (46 - 52)ColourBlack4890808200285http://cdn.edc.nl/800/BLW5005-Q.jpg114.99
55Baci Lingeriehttp://cdn.edc.nl/800/BLW5005-Q_2.jpg2
56BLW5008Baci LingerieBaci - Criss Cross Crotchless CatsuitSeduce your partner with this eye-catching catsuit! This crotchless catsuit features playful lines. The stretchy material makes for a nice fit.catsuitSizeOne Size (S-L 34 - 40)ColourBlack4890808200339http://cdn.edc.nl/800/BLW5008.jpg117.99
57Baci Lingeriehttp://cdn.edc.nl/800/BLW5008_2.jpg2
58BLW5008-QBaci LingerieBaci - Criss Cross Fishnet Crotchless Catsuit - CurvyFeel sexy and confident in this enticing crotchless catsuit. The catsuit is made of stretchy material and is cut for curves.catsuitSizeQueen Size (46 - 52)ColourBlack4890808200346http://cdn.edc.nl/800/BLW5008-Q.jpg119.99
59Baci Lingeriehttp://cdn.edc.nl/800/BLW5008-Q_2.jpg2
60BLW5011Baci LingerieBaci - Fishnet Garter Catsuit - BlackFeel sexy and confident in this eye-catching garter catsuit. The catsuit has attached garters and stockings and is completely see-through. Stretchy material, which makes for a beautiful fit.catsuitSizeOne SizeColourBlack4890808200391http://cdn.edc.nl/800/BLW5011.jpg117.99
61Baci Lingeriehttp://cdn.edc.nl/800/BLW5011_2.jpg2
62Baci Lingeriehttp://cdn.edc.nl/800/BLW5011-Q_2.jpg2
63BLW5014-QBaci LingerieBaci - Strappy Fishnet Garter-Look Catsuit - CurvyFeel sexy and confident in this eye-catching fishnet catsuit. Crotchless catsuit with a lace pattern. Stretchy material and cut for curves.catsuitSizeQueen Size (46 - 52)ColourBlack4890808200469http://cdn.edc.nl/800/BLW5014-Q.jpg119.99
64Baci Lingeriehttp://cdn.edc.nl/800/BLW5014-Q_2.jpg2
65E32340Baci LingerieBaci - White Floral and Lace 2-pcs Bra SetSpring is here, and so is this adorable two-piece light floral bra and panty set! Thoughtfully designed to be comfy and sexy, the bralette features white banding and adjustable straps, while the matching panty is cut straight at the waist and has a playful peekaboo cutout in the back.bra setSizeS/MColourWhite4890808243466http://cdn.edc.nl/800/E32340.jpg119.99
66E32341Baci LingerieBaci - White Floral and Lace 2-pcs Bra SetSpring is here, and so is this adorable two-piece light floral bra and panty set! Thoughtfully designed to be comfy and sexy, the bralette features white banding and adjustable straps, while the matching panty is cut straight at the waist and has a playful peekaboo cutout in the back.bra setSizeM/LColourWhite4890808243473http://cdn.edc.nl/800/E32340.jpg119.99
67Baci Lingeriehttp://cdn.edc.nl/800/E32340_2.jpg2
68E32342Baci LingerieBaci - White Floral &amp; Lace 2-pcs Bra Set - CurvySpring is here, and so is this adorable two-piece light floral bra and panty set! Thoughtfully designed to be comfy and sexy, the bralette features white banding and adjustable straps, while the matching panty is cut straight at the waist and has a playful peekaboo cutout in the back.bra setSizeQueen Size (46 - 52)ColourWhite4890808243480http://cdn.edc.nl/800/E32342.jpg122.99
69Baci Lingeriehttp://cdn.edc.nl/800/E32342_2.jpg2
70E32349Baci LingerieBaci - White Floral &amp; Lace Bra High Waist Bra SetPlayful details makes this light floral two-piece set flirty and fun and ready for more! A beautifully designed bra features semi-open strappy cups with an intricate white lace accent, while a flirty matching high-waisted and strappy bottom has matching lace accenting and a cheeky cut.bra setSizeS/MColourWhite4890808243558http://cdn.edc.nl/800/E32349.jpg122.99
71E32350Baci LingerieBaci - White Floral &amp; Lace Bra High Waist Bra SetPlayful details makes this light floral two-piece set flirty and fun and ready for more! A beautifully designed bra features semi-open strappy cups with an intricate white lace accent, while a flirty matching high-waisted and strappy bottom has matching lace accenting and a cheeky cut.bra setSizeM/LColourWhite4890808243565http://cdn.edc.nl/800/E32349.jpg122.99
72Baci Lingeriehttp://cdn.edc.nl/800/E32349_2.jpg2
73E32351Baci LingerieBaci - White Floral &amp; Lace High Waist Bra Set - CurvyPlayful details makes this light floral two-piece set flirty and fun and ready for more! A beautifully designed bra features semi-open strappy cups with an intricate white lace accent, while a flirty matching high-waisted and strappy bottom has matching lace accenting and a cheeky cut.bra setSizeQueen Size (46 - 52)ColourWhite4890808243572http://cdn.edc.nl/800/E32351.jpg122.99
74Baci Lingeriehttp://cdn.edc.nl/800/E32351_2.jpg2
Baci Lingerie Raw Data



Example Workbooks.csv
ABCDEFGHIJKLMNO
1Variant SKUVendorHandleTitleBody (HTML)TagsOption1 NameOption1 ValueOption2 NameOption2 ValueVariant BarcodeImage SrcImage PositionVariant ImageVariant Price
2BAD2031-QBaci LingerieBaci-StockingsBaci Stockings<h4>Lace Garter-look Stockings - Curvy</h4>Sexy lace garter-look stockings with a beautiful stretchy curve-friendly fit. These stockings pair well with other lingerie. <h4>Sheer Garter-look Stockings</h4>Sexy sheer garter-look stockings with a beautiful stretchy fit. These stockings have a wide lace waste band. These stockings pair well with other lingerie. <h4>Sheer Garter-look Stockings - Curvy</h4>Sexy sheer garter-look stockings with a beautiful stretchy curve-friendly fit. These stockings have a wide lace waste band. These stockings pair well with other lingerie. <h4>Black Sheer Seamed Stockings</h4> Sexy black sheer seamed thigh highs stretchy material. These stockings don't have stay-up support. Combine them with a garter belt and a pair of beautiful high heels. <h4>Black Sheer Seamed Stockings – Curvy</h4>Sexy black sheer seamed stockings with a cut for curves. The material is soft and stretchy. These stockings don't have stay-up support. Combine them with a garter belt and a pair of beautiful high heels. <h4>Nude Sexy Seamed Stockings</h4>Sexy, stretchy, thigh highs with black seam. Sheer, beige stockings. Combine them with a garter belt and a pair of beautiful high heels. <h4>Nude Sexy Seamed Stockings - Curvy</h4>Sexy nude sheer seamed stockings cut for curves. Stretchy material. These stockings don't have stay-up support. Combine them with a garter belt and a pair of beautiful high heels. <h4>Black Stay Up Seamed Stockings</h4> Sexy black seamed stockings. These stockings have built in silicone stay-ups around the top, so you can wear them without a garter belt. These stretchy stockings are beautifully designed. <h4>Black Stay Up Seamed Stockings - Curvy</h4>Sexy black seamed thigh highs These stockings have built in silicone stay-ups around the top, so you can wear them without a garter belt. These stretchy stockings are cut for curves. <h4>Black Sheer Silicone Stay Up Stockings with Strap</h4>Sexy, black, high stay-up stockings. These stockings have built-in silicone stay-ups around the top, so you can wear them without a garter belt. These stretchy stockings are beautifully designed. <h4>Black Sheer Silicone Stay-Up Stockings with Strap - Curvy</h4>These stylish queen-size stockings, will enticingly accentuate your legs. These stockings are detailed with a wide and striped edge. When wearing, the silicone edge perfectly keeps them up without garters. They are designed for curves. <h4>Black Sheer Garter Stockings With Polkadot Print</h4>Feel sexy in these beautiful, sheer garter stockings. The stockings have a playful polkadot print and are stretchy for a nice fit. Combine the stockings with a garter belt and a pair of beautiful high heels. StockingsStyleLace Garter-look Stockings - CurvySizeCurvy - Queen Size (46 52)4890808183205http://cdn.edc.nl/800/BAD2031-Q.jpg1http://cdn.edc.nl/800/BAD2031-Q.jpg12.99
3BAD 2032.00Baci LingerieBaci-StockingsStockingsStyleGarter-look StockingsSizeOne Size (S-L 34 40)4890808183212http://cdn.edc.nl/800/BAD2032.jpg2http://cdn.edc.nl/800/BAD2032.jpg14.99
4BAD2032-QBaci LingerieBaci-StockingsStockingsGarter-look Stockings - CurvySizeCurvy - Queen Size (46 52)4890808183229http://cdn.edc.nl/800/BAD2032-Q.jpg3http://cdn.edc.nl/800/BAD2032-Q.jpg14.99
5BAD 2033.00Baci LingerieBaci-StockingsStockingsStyleBlack Sexy Seamed StockingsSizeOne Size (S-L 34 40)4890808183236http://cdn.edc.nl/800/BAD2033.jpg4http://cdn.edc.nl/800/BAD2033.jpg9.99
6BAD2033-QBaci LingerieBaci-StockingsStockingsBlack Sexy Seamed Stockings - CurvySizeCurvy - Queen Size (46 52)4890808183243http://cdn.edc.nl/800/BAD2033-Q.jpg5http://cdn.edc.nl/800/BAD2033-Q.jpg9.99
7BAD 2034.00Baci LingerieBaci-StockingsStockingsStyleNude Sexy Seamed StockingsSizeOne Size (S-L 34 40)4890808183250http://cdn.edc.nl/800/BAD2034.jpg6http://cdn.edc.nl/800/BAD2034.jpg9.99
8BAD2034-QBaci LingerieBaci-StockingsStockingsNude Sexy Stockings with Seam - CurvySizeCurvy - Queen Size (46 52)4890808183267http://cdn.edc.nl/800/BAD2034-Q.jpg7http://cdn.edc.nl/800/BAD2034-Q.jpg9.99
9BAD 2036.00Baci LingerieBaci-StockingsStockingsStyleBlack Stay Up Seamed StockingsSizeOne Size (S-L 34 40)4890808183298http://cdn.edc.nl/800/BAD2036.jpg8http://cdn.edc.nl/800/BAD2036.jpg12.99
10BAD2036-QBaci LingerieBaci-StockingsStockingsBlack Stay Up Seamed Stockings - CurvySizeCurvy - Queen Size (46 52)4890808183304http://cdn.edc.nl/800/BAD2036-Q.jpg9http://cdn.edc.nl/800/BAD2036-Q.jpg12.99
11BAD 2037.00Baci LingerieBaci-StockingsStockingsStyleBlack Sheer Silicone Stay Up Stockings With StrapSizeOne Size (S-L 34 40)4890808183311http://cdn.edc.nl/800/BAD2037.jpg10http://cdn.edc.nl/800/BAD2037.jpg14.99
12BAD2037-QBaci LingerieBaci-StockingsStockingsBlack Sheer Silicone Stay Up Stockings With Strap - CurvySizeCurvy - Queen Size (46 52)4890808183328http://cdn.edc.nl/800/BAD2037-Q.jpg11http://cdn.edc.nl/800/BAD2037-Q.jpg14.99
13BAD 2038.00Baci LingerieBaci-StockingsStockingsStyleBlack Sheer Garter Stockings With Polkadot PrintSizeOne Size (S-L 34 40)4890808183335http://cdn.edc.nl/800/BAD2038.jpg12http://cdn.edc.nl/800/BAD2038.jpg14.99
14BLD1260Baci LingerieBaci-School-Girl-CostumeBaci School Girl Costume<h4>Sexy School Girl with Tie</h4>Seduce your partner and entice each other's fantasy with this School Girl Costume! Particularly suited for exciting role-play. The costume includes of a nicely fitted black top with a removable tie. The matching wide skirt has a lace ruffle at the bottom. Stretchy material, which makes for a beautiful fit. <h4>Naughty School Girl </h4>Seduce your partner and entice each other's fantasy with this School Girl Costume! Particularly suited for exciting role-play. The costume includes a beautifully fitted sheer top with a collar and short sleeves. You tie the top at the front. The matching wide skirt has a lace ruffle at the bottom. The material is stretchy, which makes for a nice fit. <h4>Naughty School Girl </h4>Seduce your partner and entice each-other's fantasy with this School Girl Costume! Particularly suited for exciting role-play. The costume includes a beautifully fitted top and a matching wide-fitting checkered skirt. The top has a halter neck and a playful bow. The material is stretchy, which makes for a nice fit. <h4>2Pcs Black/Red School Girl</h4>Seduce your partner and entice each other's fantasy with this School Girl Costume! Particularly suited for exciting role-play. The costume includes a beautifully fitted top and a matching wide-fitting checkered skirt. The top has a halter neck and a playful bow. Stretchy material, which makes for a beautiful fit. <h4>Boarding School Girl</h4>Seduce your partner and entice each other's fantasy with this Boarding School Girl Costume! Particularly suited for exciting role-play. The costume includes a beautifully fitted top with collar and short sleeves. You tie the top at the front. The matching wide pleated skirt completes this look. Stretchy material, which makes for a beautiful fit. <h4>Studious School Girl </h4>Seduce your partner and entice each other's fantasy with this Studious School Girl Costume! Particularly suited for exciting role-play. The costume includes a beautifully fitted top with collar and short sleeves. You tie the top at the front. The matching wide pleated skirt completes this look. Stretchy material, which makes for a beautiful fit. <h4>Sweet School Girl</h4>Seduce your partner and entice each other's fantasy with this School Girl Costume! Particularly suited for exciting role-play. The costume includes a beautifully fitted sheer top with a collar and short sleeves. You tie the top at the front. The matching checkered skirt is wide and short and completes the look. Stretchy material, which makes for a beautiful fit. <h4>Sexy School Girl with Tie</h4>Seduce your partner and spark each other's fantasies with this School Girl Costume! It's perfect for exciting role-play. The costume includes a gorgeous fitted top with a collar and short sleeves. The top ties at the front. The matching wide skirt has a lace ruffle at the bottom. Stretchy material, which makes for a beautiful fit. <b>One Size (S - M)</b>School GirlStyleSexy School Girl with Tie4890808123171http://cdn.edc.nl/800/BLD1260_2.jpg1http://cdn.edc.nl/800/BLD1260.jpg29.99
15BLD1265Baci LingerieBaci-School-Girl-CostumeSchool GirlNaughty School Girl 4890808123225http://cdn.edc.nl/800/BLD1265.jpg2http://cdn.edc.nl/800/BLD1265.jpg29.99
16BLD1266Baci LingerieBaci-School-Girl-CostumeSchool Girl2Pcs School Girl4890808123232http://cdn.edc.nl/800/BLD1266_2.jpg3http://cdn.edc.nl/800/BLD1266_2.jpg27.99
17BLD1267Baci LingerieBaci-School-Girl-CostumeSchool Girl2Pcs Black/Red School Girl4890808123249http://cdn.edc.nl/800/BLD1267.jpg4http://cdn.edc.nl/800/BLD1267.jpg27.99
18BLD1270Baci LingerieBaci-School-Girl-CostumeSchool GirlBoarding School Girl4890808123324http://cdn.edc.nl/800/BLD1270_2.jpg5http://cdn.edc.nl/800/BLD1270.jpg29.99
19BLD1271Baci LingerieBaci-School-Girl-CostumeSchool GirlStudious School Girl 4890808123355http://cdn.edc.nl/800/BLD1271.jpg6http://cdn.edc.nl/800/BLD1271.jpg29.99
20BLD1275Baci LingerieBaci-School-Girl-CostumeSchool GirlSweet School Girl4890808123393http://cdn.edc.nl/800/BLD1275_2.jpg7http://cdn.edc.nl/800/BLD1275.jpg29.99
21BLD1276Baci LingerieBaci-School-Girl-CostumeSchool GirlSexy School Girl4890808123409http://cdn.edc.nl/800/BLD1276.jpg8http://cdn.edc.nl/800/BLD1276.jpg32.99
22BLW3124Baci LingerieBaci-CatsuitBaci Catsuit"<h4>Lace Corset-look Catsuit</h4>Feel sexy and confident in this eye-catching lace catsuit. This corset-look catsuit is made from stretchy material for a beautiful fit. <h4>Lace Corset-look Catsuit - Curvy</h4>Feel sexy and confident in this eye-catching lace garter catsuit. The catsuit has attached garters and is completely see-through. The catsuit is made of stretchy material and is cut for curves. <h4>Fishnet Garter Catsuit - Curvy</h4>Feel sexy and confident in this eye-catching garter catsuit. The catsuit has attached garters and stockings and is completely see-through. Stretchy material, which makes for a beautiful fit. <h4>Crotchless Garter-look Catsuit</h4>You will feel sexy in this striking, crotchless catsuit with sheer cups. This garter-look catsuit features a playful flower print. The stretchy material makes for a great fit. <h4>Crotchless Garter-look Catsuit</h4>You will feel sexy in this striking, crotchless catsuit with sheer cups. This catsuit is designed for curves and made from stretchy material for a beautiful fit. <h4>Sexy Long-Sleeved Crotchless Fishnet Catsuit</h4>Feel sexy and confident in this beautiful long-sleeved fishnet catsuit. This crotchless catsuit is made from stretchy material for a beautiful fit. <h4>Sexy Long-Sleeved Crotchless Fishnet Catsuit</h4>Feel sexy and confident in this eye-catching fishnet garter catsuit. The catsuit has long sleeves and attached garters. The catsuit is made of stretchy material and is cut for curves. <h4>Curvy One Shoulder Crotchless Fishnet Catsuit </h4>Feel sexy and confident in this enticing crotchless catsuit. The catsuit is made of stretchy material and is cut for curves. <h4>Curvy Sexy Catsuit with Revealing Sides</h4>Feel sexy and confident in this eye-catching fishnet catsuit. Crotchless catsuit with a lace pattern. Stretchy material and cut for curves. <h4>Criss Cross Crotchless Catsuit</h4>Seduce your partner with this eye-catching catsuit! This crotchless catsuit features playful lines. The stretchy material makes for a nice fit. <h4>Criss Cross Crotchless Catsuit - Curvy</h4>Feel sexy and confident in this enticing crotchless catsuit. The catsuit is made of stretchy material and is cut for curves. <h4>Strappy Fishnet Garter-Look Catsuit – Curvy</h4>Feel sexy and confident in this eye-catching fishnet catsuit. Crotchless catsuit with a lace pattern. Stretchy material and cut for curves. "CatsuitStyleLace Corset-look CatsuitSizeOne Size S-L (34 - 40)4890808176412http://cdn.edc.nl/800/BLW3124.jpg1http://cdn.edc.nl/800/BLW3124.jpg19.99
23BLW3124-QBaci LingerieBaci-CatsuitCatsuitLace Corset-look CatsuitSizeQueen Size (46 52)4890808176429http://cdn.edc.nl/800/BLW3124-Q.jpg2http://cdn.edc.nl/800/BLW3124-Q.jpg22.99
24BLW3125-QBaci LingerieBaci-CatsuitCatsuitStyleCurvy Fishnet Garter CatsuitSizeQueen Size (46 52)4890808176467http://cdn.edc.nl/800/BLW3125-Q.jpg3http://cdn.edc.nl/800/BLW3125-Q.jpg17.99
25BLW5000Baci LingerieBaci-CatsuitCatsuitStyleCrothchless Garter-look CatsuitSizeOne Size S-L (34 - 40)4890808200179http://cdn.edc.nl/800/BLW5000.jpg4http://cdn.edc.nl/800/BLW5000.jpg17.99
26BLW5000-QBaci LingerieBaci-CatsuitCatsuitCrothchless Garter-look CatsuitSizeQueen Size (46 52)4890808200186http://cdn.edc.nl/800/BLW5000-Q.jpg5http://cdn.edc.nl/800/BLW5000-Q.jpg19.99
27BLW5001Baci LingerieBaci-CatsuitCatsuitStyleSexy Long-Sleeved Crotchless Fishnet CatsuitSizeOne Size S-L (34 - 40)4890808200193http://cdn.edc.nl/800/BLW5001.jpg6http://cdn.edc.nl/800/BLW5001.jpg19.99
28BLW5001-QBaci LingerieBaci-CatsuitCatsuitSexy Long-Sleeved Crotchless Fishnet CatsuitSizeQueen Size (46 52)4890808200209http://cdn.edc.nl/800/BLW5001-Q.jpg7http://cdn.edc.nl/800/BLW5001-Q.jpg22.99
29BLW5003-QBaci LingerieBaci-CatsuitCatsuitStyleCurvy One Shoulder Crotchless Fishnet Catsuit SizeQueen Size (46 52)4890808200247http://cdn.edc.nl/800/BLW5003-Q.jpg8http://cdn.edc.nl/800/BLW5003-Q.jpg19.99
30BLW5005-QBaci LingerieBaci-CatsuitCatsuitStyleCurvy Sexy Catsuit With Revealing SidesSizeQueen Size (46 52)4890808200285http://cdn.edc.nl/800/BLW5005-Q.jpg9http://cdn.edc.nl/800/BLW5005-Q.jpg14.99
31BLW5008Baci LingerieBaci-CatsuitCatsuitStyleCriss Cross Crotchless CatsuitSizeOne Size S-L (34 - 40)4890808200339http://cdn.edc.nl/800/BLW5008.jpg10http://cdn.edc.nl/800/BLW5008.jpg17.99
32BLW5008-QBaci LingerieBaci-CatsuitCatsuitCriss Cross Crotchless CatsuitSizeQueen Size (46 52)4890808200346http://cdn.edc.nl/800/BLW5008-Q.jpg11http://cdn.edc.nl/800/BLW5008-Q.jpg19.99
33BLW5014-QBaci LingerieBaci-CatsuitCatsuitStyleCurvy Strappy Fishnet Garter-Look CatsuitSizeQueen Size (46 52)4890808200469http://cdn.edc.nl/800/BLW5014-Q.jpg12http://cdn.edc.nl/800/BLW5014-Q.jpg19.99
34BLW3106-BLKBaci LingerieBaci-Bra-SetBaci Bra Set<h4>Strappy Open Cup Bra Set</h4>Baci Bra SetSeduce your partner with this revealing bra set. This set features a playful polka dot print, open cups and adjustable bra straps. The stretchy material makes for a great fit. <h4>White Floral And Lace 2-Pcs Bra Set</h4>Spring is here, and so is this adorable twoPcs light floral bra and panty set! Thoughtfully designed to be comfy and sexy, the bralette features white banding and adjustable straps, while the matching panty is cut straight at the waist and has a playful peekaboo cutout in the back. <h4>White Floral Lace High Waist Bra Set</h4>Playful details makes this light floral twoPcs set flirty and fun and ready for more! A beautifully designed bra features semi-open strappy cups with an intricate white lace accent, while a flirty matching high-waisted and strappy bottom has matching lace accenting and a cheeky cut.Bra SetStyleBlack Strappy Open Cup Bra Set4890808166109http://cdn.edc.nl/800/BLW3106-BLK.jpg1http://cdn.edc.nl/800/BLW3106-BLK.jpg19.99
35BLW3106-REDBaci LingerieBaci-Bra-SetBra SetRed Strappy Open Cup Bra Set4890808166116http://cdn.edc.nl/800/BLW3106-RED.jpg2http://cdn.edc.nl/800/BLW3106-RED.jpg19.99
36E32340Baci LingerieBaci-Bra-SetBra SetWhite Floral And Lace 2Pcs Bra Set S/M4890808243466http://cdn.edc.nl/800/E32340.jpg3http://cdn.edc.nl/800/E32340.jpg19.99
37E32341Baci LingerieBaci-Bra-SetBra SetWhite Floral And Lace 2Pcs Bra Set M/L4890808243473http://cdn.edc.nl/800/E32340_2.jpg4http://cdn.edc.nl/800/E32340_2.jpg19.99
38E32342Baci LingerieBaci-Bra-SetBra SetWhite Floral and Lace 2Pcs Bra Set Queen Size4890808243480http://cdn.edc.nl/800/E32342.jpg5http://cdn.edc.nl/800/E32342.jpg22.99
39E32349Baci LingerieBaci-Bra-SetBra SetWhite Floral Lace High Waist Bra Set S/M4890808243558http://cdn.edc.nl/800/E32349.jpg6http://cdn.edc.nl/800/E32349.jpg22.99
40E32350Baci LingerieBaci-Bra-SetBra SetWhite Floral Lace High Waist Bra Set M/L4890808243565http://cdn.edc.nl/800/E32350.jpg7http://cdn.edc.nl/800/E32350.jpg22.99
41E32351Baci LingerieBaci-Bra-SetBra SetWhite Floral Lace High Waist Bra Set Queen Size4890808243572http://cdn.edc.nl/800/E32351.jpg8http://cdn.edc.nl/800/E32351.jpg22.99
Baci Lingerie Result
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Hello, FYI. In the first mini sheet I have 66 lines of data with 24 products. In the second mini sheet I have 25 lines of data but only 4 products to upload onto the website. Hope this all makes sense now.

Thank you
 
Upvote 0

Forum statistics

Threads
1,214,979
Messages
6,122,552
Members
449,088
Latest member
davidcom

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top