Hi - I have a product that has many variations and each variation has a unique set of product parts. For example, one of my products has 27 variations and each of the 27 variations has a unique combination of product parts. I had hoped to use the import feature of Export Pro to make this easier but I am running into a problem. When I use the woocommerce web interface to add a product part to a variation, I can see from exporting the information using Export Pro, that the system generates a unique ID called "Linked BOM ID" (this is a subentity under the ATUM Linked BOMs category in Export Pro). There doesn't seem to be a way to use the import feature of Export Pro to generate this Linked BOM ID.
Here is what I'm doing:
1) Create a Variable Product using the web interface
2) Generate all of the variations using the web interface (in my example I have 27 variations as I have 3 attribute categories, each having 3 possible values)
3) Use my custom template to export the IDs of my variable product and each of the variations
4) I have noticed that for every product part that I add to a variation, a new database entry is created having the same ID as the variation (in other words, there are multiple rows with the same ID for the given variation). The difference between each row is just the BOM ID for the product part, and the "Linked BOM ID" that was generated which seems to be a unique identifier that was created when I added the product part to the variation
5) Let's say I'm looking at a variation having ID 1001 and I used the web interface to add two product parts to that variation having IDs 600 and 601 (these values would show up in the "bom_id" column). I would have 2 rows, the first having ID 1001 and bom_id 600 and the second having ID 1001 and bom_id 601. In addition, the system generates a Linked BOM ID (column "id") for each row. For this example, lets assume the first row with bom_id 600 is 20 and the second row is 21.
6) I'd like to add another product part to variation 1001, so I create a new row having ID 1001, bom_id 602 and Linked BOM ID of 22 (the next number in the sequence). When I try to import this new item, I get an error, and the error seems to be because Linked BOM ID does not already exist.
There does not seem to be a way to have the system generate a Linked BOM ID when I "update" a variation to include a new product part. Is that the case? Or is there some workaround you can suggest? Thanks.
