Woocommerce - pragmatically create products and variation from external db
Budget: €500 – €1,000 EUR
I need to create a connector to an external db source to navigate categories, sub categroies and products in woocommerce but connecting to an external quite simple DB that is generated by a custom catalogue software.
Category tree is simple, just name and pic. Products have name, sky, description, pics (jpgs named as sku and added of progressive numbers like _01, _02 ....) and VARIATIONS
Product variations are based on 4 attrbutes, this is the only quite complicated thing. Once read the product we must read a first data that is the product quantity lot, once choosen the lot we have to serach and choose the colour.... onece choosen the colour we have to read for example the material.... an so on for 4 maximum attributes (different for some products but in any case clearly indicated in data structure)
Once the product is defined in the product page (every varaition has been choosed) i need to add it to the cart pragmatically
NOTE: the price that is obtained choosing the variations can be manually modifid by users that have partciular roles (for ex administrator) - so for a customer if the variation combination generates .... 10.50€ an admin user can change this price putting 10€ manually (before adding this product pragmatically into the cart)
The tables are updated by and external source but are resident on the same db running wp
That's all
Category tree is simple, just name and pic. Products have name, sky, description, pics (jpgs named as sku and added of progressive numbers like _01, _02 ....) and VARIATIONS
Product variations are based on 4 attrbutes, this is the only quite complicated thing. Once read the product we must read a first data that is the product quantity lot, once choosen the lot we have to serach and choose the colour.... onece choosen the colour we have to read for example the material.... an so on for 4 maximum attributes (different for some products but in any case clearly indicated in data structure)
Once the product is defined in the product page (every varaition has been choosed) i need to add it to the cart pragmatically
NOTE: the price that is obtained choosing the variations can be manually modifid by users that have partciular roles (for ex administrator) - so for a customer if the variation combination generates .... 10.50€ an admin user can change this price putting 10€ manually (before adding this product pragmatically into the cart)
The tables are updated by and external source but are resident on the same db running wp
That's all