Hi,
I have a product catalog, as an example lets say its for shoes.
column B holds the model number (Handle), column C holds the Name (Title).
there are 3 different types of products:
Regular products - For example: Women stiletto heels brown color size 6
Master products - For example: Nike model 270C
Variant products - For example: Nike model 270C - Brown size 8
Master products are not "real" items, they are the "Master" model. think of purchasing shoes online, you can not purchase "Nike model 270C", it needs to be more specific... You can purchase: Nike model 270C - Brown size 8
The Variant products are the "real" items under the Master product.
I need help in finding a way of locating the Master products and their Variants. then giving each Variant product the model number (Handle) of its own Master.
In the below image, the Variant product (line 4) should have the Handle of its Master product (cell A3)
the only way to know that an item (a line in the excel) is a Variant item that has a Master (Vs a regular product) is by its Title which is identical to its Master just longer. the Variant product title Always as a "-" followed by the specific color/model/size
Example:
Nike model 270C
Nike model 270C - Brown size 8
Screen Shot 2019-02-12 at 11.08.09.jpg
Attached sample .xlsx with just over 20 lines of sample data. its missing more than the above but once I understand how to do the above I think i can manage the rest.
For anyone downloading the sample .xlsx - The part I need assistance with is in sheet "READY".
Thank you for taking the time reading the above.
Any help is appreciated.
Ziv
Bookmarks