Hello,
So the use case here is that we have a store with 50,000 products and we will start building additional stores.
So I want to have a main product table where all the products are. This one is already done in Excel. Then I want to add checkboxes for B2B, IT, DE, and FR (Italy, Germany, France). So when I click on the checkbox on the main list it should appear in the additional list. So when I click on b2b it should appear on b2b with all relevant data. In b2b I have additional fields where for b2b pricing for A, B, and C that I calculate with certain formulas based on Acquisition pricing. Up to this point, it was easy. I already did this with automation.
But where the problem comes is how the hell do I delete the record after? So I have it in b2b now. But let's say I don't want to sell it in b2b and I remove the checkbox. The records need to be deleted from b2b. I was thinking that the checkbox should be a relationship field that is the same in both tables and if I unchecked it in b2b or the main table the records should be removed but ONLY from the b2b table. The same use cases go for other countries, IT, DE. There will be additional fields for translated titles, translated descriptions, and so on.
Other question and uses cases are. How do I cost-effectively automate this with WooCommerce? We will be moving 50k+ data to WooCommerce daily and Integromat and stuff like that that charges per record are expensive as hell for use cases like this. Did anyone make a nice integration with Woo? I didn't find any on Google. I'm not sure how to get records from Airtable to WooCommerce 😞
Another use case is that we will sometimes use Deepl API to translate. I haven't tried this one yet but probably I can do this with Intergromat. So when I click on the checkbox "translate" it will run Deepl automatic translation.
I was looking for a tool that I could use for this use case for a long time. I tried Pimcore and Akeneo PIM but so far Aitrable beats them in simplicity and automation.
Any help and advice are appreciated!!