Line 59:
Line 59:
|Categories created/modified into Woocommerce || Created into Dolibarr as sub-categories of the parent category used for Mangeto categories (defined into module setup) || Manual click on "Woocommerce to Dolibarr sync" button || <div style="color: #600">NA</div>Table llx_ecommerce_category is updated to store a link between dolibarr category id and remote Woocommerce id. Due to a lack of search on last modified time on Woocommerce API, this sync may be slow if you have a high number of categories
|Categories created/modified into Woocommerce || Created into Dolibarr as sub-categories of the parent category used for Mangeto categories (defined into module setup) || Manual click on "Woocommerce to Dolibarr sync" button || <div style="color: #600">NA</div>Table llx_ecommerce_category is updated to store a link between dolibarr category id and remote Woocommerce id. Due to a lack of search on last modified time on Woocommerce API, this sync may be slow if you have a high number of categories
|-
|-
−
| Products or Stock created/modified into Woocommerce || Created into Dolibarr (and linked to its categories <span style="color: #600">NA</span>).<br>If module stock is enabled and '''Stock synchronisation direction''' was set to "ecommerce2dolibarr", stock is also initialised/updated into warehouse defined into eCommerce dolibarr module setup || Manual click on "Woocommerce to Dolibarr sync" button || Table llx_ecommerce_product is updated to store a link between dolibarr product id and remote Woocommerce id<br><br>Informations concerned:<br> - Product : Product type (Product or Service(=Virtual in Woocommerce)), Ref (UGS in Woocommerce, Activated 'Elephant' code generator in module preferences if UGS is maybe empty), Label (Name in Woocommerce), Description, Weigth (Kg), Price, envente (Purchasable in Woocommerce), Product finished type (Fixed at Manufactured), Min price (Price in Woocommerce), Url (Permalink in Woocommerce), Stock quantity<br> - Product Variation : Product type (Product or Service(=Virtual in Woocommerce)), Ref (UGS in Woocommerce, Activated 'Elephant' code generator in module preferences if UGS is maybe empty), Label (Name & liste (attribute name: attribute option) in Woocommerce), Description, Weigth (Kg), Price, envente (Purchasable in Woocommerce), Product finished type (Fixed at Manufactured), Min price (Price in Woocommerce), Url (Permalink in Woocommerce), Stock quantity
+
| Products or Stock created/modified into Woocommerce || Created into Dolibarr (and linked to its categories <span style="color: #600">NA</span>).<br>If module stock is enabled and '''Stock synchronisation direction''' was set to "ecommerce2dolibarr", stock is also initialised/updated into warehouse defined into eCommerce dolibarr module setup || Manual click on "Woocommerce to Dolibarr sync" button || <div style="color: #060">Available</div>Table llx_ecommerce_product is updated to store a link between dolibarr product id and remote Woocommerce id<br><br>Informations concerned:<br> - Product : Product type (Product or Service(=Virtual in Woocommerce)), Ref (UGS in Woocommerce, Activated 'Elephant' code generator in module preferences if UGS is maybe empty), Label (Name in Woocommerce), Description, Weigth (Kg), Price, envente (Purchasable in Woocommerce), Product finished type (Fixed at Manufactured), Min price (Price in Woocommerce), Url (Permalink in Woocommerce), Stock quantity<br> - Product Variation : Product type (Product or Service(=Virtual in Woocommerce)), Ref (UGS in Woocommerce, Activated 'Elephant' code generator in module preferences if UGS is maybe empty), Label (Name & liste (attribute name: attribute option) in Woocommerce), Description, Weigth (Kg), Price, envente (Purchasable in Woocommerce), Product finished type (Fixed at Manufactured), Min price (Price in Woocommerce), Url (Permalink in Woocommerce), Stock quantity
|-
|-
−
| Thirdparties and contact/addresses created/modified into Woocommerce || Created into Dolibarr || Manual click on "Woocommerce to Dolibarr sync" button || Table llx_ecommerce_societe and llx_ecommerce_socpeople is updated to store a link between dolibarr thirdparty id and remote Woocommerce id. To know if a thirdparty already exists, Woocommerce check on the ref. To know if a contact already exists, Woocommerce check on all fields firstname, lastname, address, zip, town (and thirdparty).<br><br>Informations concerned:<br> - Thirdparties : Name (First name & Last Name), Email, Type client (Fixed at Client/Prospect)<br> - Contact/addresses - Billing: Type (Fixed at Invoice), Name and last name ('Billing' by default or ECOMMERCENG_BILLING_CONTACT_NAME), Email, Address (Address 1 & Address 2), City, Postcode, Country, Phone<br> - Contact/addresses - Shipping (If not set, set from billing address): Type (Fixed at Delivery), Name and last name ('Shipping' by default or ECOMMERCENG_SHIPPING_CONTACT_NAME), Address (Address 1 & Address 2), City, Postcode, Country
+
| Thirdparties and contact/addresses created/modified into Woocommerce || Created into Dolibarr || Manual click on "Woocommerce to Dolibarr sync" button || <div style="color: #060">Available</div>Table llx_ecommerce_societe and llx_ecommerce_socpeople is updated to store a link between dolibarr thirdparty id and remote Woocommerce id. To know if a thirdparty already exists, Woocommerce check on the ref. To know if a contact already exists, Woocommerce check on all fields firstname, lastname, address, zip, town (and thirdparty).<br><br>Informations concerned:<br> - Thirdparties : Name (First name & Last Name), Email, Type client (Fixed at Client/Prospect)<br> - Contact/addresses - Billing: Type (Fixed at Invoice), Name and last name ('Billing' by default or ECOMMERCENG_BILLING_CONTACT_NAME), Email, Address (Address 1 & Address 2), City, Postcode, Country, Phone<br> - Contact/addresses - Shipping (If not set, set from billing address): Type (Fixed at Delivery), Name and last name ('Shipping' by default or ECOMMERCENG_SHIPPING_CONTACT_NAME), Address (Address 1 & Address 2), City, Postcode, Country
|-
|-
−
| Orders created/modified into Woocommerce || Created into Dolibarr || Manual click on "Woocommerce to Dolibarr sync" button || Table llx_ecommerce_commande is updated to store link of dolibarr order id and remote Woocommerce id<br><br>Informations concerned:<br> Order created by Other than Customer user (Administrator, Anonymous, ...) is not created/modified<br> - Order: Ref client (Id order in Woocommerce), Date commande (Created date in Woocommerce), Delivery date (Completed date in Woocommerce), Status (pending => Validated, on-hold & processing => Accepted, cancelled & Failed => Cancelled, Completed & Refunded => Closed), Billed status (pending & processing & on-hold & cancelled & Failed => Not paid, Completed & Refunded => Paid), Private note (Customer note in Woocommerce)<br> - Item: Description (Name in Woocommerce), Product type (Fixed at Simple), Price, Quantity, VAT rate (Calculated with total and total tax closed to VAT rate in Dolibarr)<br> - Shipping line into item (Displayed by default or ECOMMERCENG_SHIPPING_NOT_DISPLAY_IF_NULL): Description ('Shipping - ' & Shipping method title in Woocommerce if present), Price (Total shipping in Woocommerce), VAT rate (Calculated with shipping total and shipping tax closed to VAT rate in Dolibarr)<br> - Order address: Billing Contact/addresses in Thirdparties<br> - Invoice address: Billing Contact/addresses in Thirdparties<br> - Shipping address: Shipping Contact/addresses in Thirdparties
+
| Orders created/modified into Woocommerce || Created into Dolibarr || Manual click on "Woocommerce to Dolibarr sync" button || <div style="color: #060">Available</div>Table llx_ecommerce_commande is updated to store link of dolibarr order id and remote Woocommerce id<br><br>Informations concerned:<br> Order created by Other than Customer user (Administrator, Anonymous, ...) is not created/modified<br> - Order: Ref client (Id order in Woocommerce), Date commande (Created date in Woocommerce), Delivery date (Completed date in Woocommerce), Status (pending => Validated, on-hold & processing => Accepted, cancelled & Failed => Cancelled, Completed & Refunded => Closed), Billed status (pending & processing & on-hold & cancelled & Failed => Not paid, Completed & Refunded => Paid), Private note (Customer note in Woocommerce)<br> - Item: Description (Name in Woocommerce), Product type (Fixed at Simple), Price, Quantity, VAT rate (Calculated with total and total tax closed to VAT rate in Dolibarr)<br> - Shipping line into item (Displayed by default or ECOMMERCENG_SHIPPING_NOT_DISPLAY_IF_NULL): Description ('Shipping - ' & Shipping method title in Woocommerce if present), Price (Total shipping in Woocommerce), VAT rate (Calculated with shipping total and shipping tax closed to VAT rate in Dolibarr)<br> - Order address: Billing Contact/addresses in Thirdparties<br> - Invoice address: Billing Contact/addresses in Thirdparties<br> - Shipping address: Shipping Contact/addresses in Thirdparties
|-
|-