Changes

Line 61: Line 61:  
(defined in the eCommerce dolibarr module setup) || It requires the user to click on "Woocommerce to Dolibarr sync" button || <div style="color: #060">Available</div>Table llx_ecommerce_product is updated to remember the link between dolibarr product id and remote Woocommerce id<br><br>Informations concerned:<br>&nbsp;&nbsp;- Product : Product type (Product or Service(=Virtual in Woocommerce)), Ref (UGS in Woocommerce, Activated 'Elephant' code generator in module preferences if UGS is probably 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>&nbsp;&nbsp;- 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
 
(defined in the eCommerce dolibarr module setup) || It requires the user to click on "Woocommerce to Dolibarr sync" button || <div style="color: #060">Available</div>Table llx_ecommerce_product is updated to remember the link between dolibarr product id and remote Woocommerce id<br><br>Informations concerned:<br>&nbsp;&nbsp;- Product : Product type (Product or Service(=Virtual in Woocommerce)), Ref (UGS in Woocommerce, Activated 'Elephant' code generator in module preferences if UGS is probably 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>&nbsp;&nbsp;- 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 contacts/addresses created/modified into Woocommerce || They are also created in Dolibarr || It requires the user to click on "Woocommerce to Dolibarr sync" button || <div style="color: #060">Available</div>Table llx_ecommerce_societe and llx_ecommerce_socpeople is updated to remember the link between dolibarr thirdparty id and remote Woocommerce id. To determine if a thirdparty already exists, Woocommerce checks the ref. To determine if a contact already exists, Woocommerce checks all fields: firstname, lastname, address, zip, town (and thirdparty).<br><br>Informations concerned:<br>&nbsp;&nbsp;- Thirdparties : Name (First name & Last Name), Email, Type client (Fixed at Client/Prospect)<br>&nbsp;&nbsp;- 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>&nbsp;&nbsp;- 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, ZIP, Country
+
| Thirdparties and contacts/addresses created/modified into Woocommerce || They are also created in Dolibarr || It requires the user to click on "Woocommerce to Dolibarr sync" button || <div style="color: #060">Available</div>Table llx_ecommerce_societe and llx_ecommerce_socpeople is updated to remember the link between dolibarr thirdparty id and remote Woocommerce id. To determine if a thirdparty already exists, Woocommerce checks the ref. To determine if a contact already exists, Woocommerce checks all fields: firstname, last name, address, zip, town (and thirdparty).<br><br>Informations concerned:<br>&nbsp;&nbsp;- Thirdparties : Name (First name & Last Name), Email, Type client (Fixed at Client/Prospect)<br>&nbsp;&nbsp;- 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>&nbsp;&nbsp;- Contact/addresses - Shipping (If they are not set up, it could be done from the billing address): Type (Fixed at Delivery), Name and last name ('Shipping' by default or ECOMMERCENG_SHIPPING_CONTACT_NAME), Address (Address 1 & Address 2), City, ZIP, Country
    
|-
 
|-
| Orders created/modified  in Woocommerce || They are also created in Dolibarr || It requires the user to click on "Woocommerce to Dolibarr sync" button || <div style="color: #060">Available</div>Table llx_ecommerce_order is updated to remember the link of dolibarr order id and remote Woocommerce id<br><br>Informations concerned:<br>&nbsp;&nbsp; The orders created by an other person than Customer user (Administrator, Anonymous, ...) are not created/modified<br>&nbsp;&nbsp;- Order: Ref client (Id order in Woocommerce),Purchase order date (Created date in Woocommerce), Delivery date (Completed date in Woocommerce), Status (pending => Validated, on-hold & processing => Accepted, cancelled & Failed => Cancelled, Completed & Refunded => Closed), Payment status (pending & processing & on-hold & cancelled & Failed => Not paid, Completed & Refunded => Paid), Private note (Customer's notes in Woocommerce)<br>&nbsp;&nbsp;- 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>&nbsp;&nbsp;- 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>&nbsp;&nbsp;- Order address: Billing Contact/addresses in Thirdparties<br>&nbsp;&nbsp;- Invoice address: Billing Contact/addresses in Thirdparties<br>&nbsp;&nbsp;- Shipping address: Shipping Contact/addresses in Thirdparties
+
| Orders created/modified  in Woocommerce || They are also created in Dolibarr || It requires the user to click on "Woocommerce to Dolibarr sync" button || <div style="color: #060">Available</div>Table llx_ecommerce_order is updated to remember the link of dolibarr order id and remote Woocommerce id<br><br>Informations concerned:<br>&nbsp;&nbsp; The orders created by another person than Customer user (Administrator, Anonymous, ...) are not created/modified<br>&nbsp;&nbsp;- Order: Ref client (Id order in Woocommerce),Purchase order date (Created date in Woocommerce), Delivery date (Completed date in Woocommerce), Status (pending => Validated, on-hold & processing => Accepted, cancelled & Failed => Cancelled, Completed & Refunded => Closed), Payment status (pending & processing & on-hold & cancelled & Failed => Not paid, Completed & Refunded => Paid), Private note (Customer's notes in Woocommerce)<br>&nbsp;&nbsp;- Product: 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>&nbsp;&nbsp;- Shipping line of the product (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>&nbsp;&nbsp;- Order address: Billing Contact/addresses in Thirdparties<br>&nbsp;&nbsp;- Invoice address: Billing Contact/addresses in Thirdparties<br>&nbsp;&nbsp;- Shipping address: Shipping Contact/addresses in Thirdparties
    
|-
 
|-
| Shipment created/modified in Woocommerce || By creating a shipment in Woocommerce the statut of the order is changing from "pending" to "processing". Considering the modified status of the order, see the cas above "Order created/modified in Woocommerce". || It requires the user to click on "Woocommerce to Dolibarr sync" button ||<div style="color: #600">NA</div>''Note:'' The shipment is not downloaded onto Dolibarr, only the status of Dolibarr Order will be changed according to the Woocommerce order.<br>''Note:'' You may choose to manage shipment in Dolibarr or in Woocommerce (we recommand to create/update the shipments on Dolibarr rather than on Woocommerce).
+
| Shipment created/modified in Woocommerce || By creating a shipment in Woocommerce the statut of the order is changing from "pending" to "processing". Considering the modified status of the order, see the cas above "Order created/modified in Woocommerce". || It requires the user to click on "Woocommerce to Dolibarr sync" button ||<div style="color: #600">NA</div>''Note:'' The shipment is not downloaded onto Dolibarr, only the status of Dolibarr Order is changing according to the Woocommerce order.<br>''Note:'' You may choose to manage shipment in Dolibarr or in Woocommerce (we recommand to create/update the shipments on Dolibarr rather than on Woocommerce).
    
|-
 
|-
Line 100: Line 100:  
| Contacts/addresses modified in Dolibarr || The update into Woocommerce is done if the contact/address is linked to Woocommerce (contact/address was created by a "Woocommerce to Dolibarr sync") || In real time || <div style="color: #060">Available</div><br>Informations concerned:<br>&nbsp;&nbsp;- Contacts/addresses Billing (CONTACT_MODIFY event): Address 1 (First address row in Dolibarr), Address 2 (Next address row in Dolibarr), City (Town in Dolibarr), Postcode (Zip in Dolibarr), Country, Phone (Phone pro in Dolibarr)<br>&nbsp;&nbsp;- Contact/addresses Shipping (CONTACT_MODIFY event): Address 1 (First address row in Dolibarr), Address 2 (Next address row in Dolibarr), City (Town in Dolibarr), Postcode (Zip in Dolibarr), Country
 
| Contacts/addresses modified in Dolibarr || The update into Woocommerce is done if the contact/address is linked to Woocommerce (contact/address was created by a "Woocommerce to Dolibarr sync") || In real time || <div style="color: #060">Available</div><br>Informations concerned:<br>&nbsp;&nbsp;- Contacts/addresses Billing (CONTACT_MODIFY event): Address 1 (First address row in Dolibarr), Address 2 (Next address row in Dolibarr), City (Town in Dolibarr), Postcode (Zip in Dolibarr), Country, Phone (Phone pro in Dolibarr)<br>&nbsp;&nbsp;- Contact/addresses Shipping (CONTACT_MODIFY event): Address 1 (First address row in Dolibarr), Address 2 (Next address row in Dolibarr), City (Town in Dolibarr), Postcode (Zip in Dolibarr), Country
 
|-
 
|-
| Orders created (validated) in Dolibarr || None ||  || Orders are created directly into backoffice, there is no need to appear into ecommerce. See next cas below.
+
| Orders created (validated) in Dolibarr || None ||  || Orders are created directly in the backoffice, it's not necessary to appear in the ecommerce. See next cas below.
 
|-
 
|-
| Orders modified into Dolibarr || The Order will be updated in Woocommerce if it is  linked to Woocommerce (the order was created by a "Woocommerce to Dolibarr sync") || In real time || <div style="color: #060">Available</div><br>Informations concerned:<br>&nbsp;&nbsp;- Order (ORDER_MODIFY & ORDER_CLOSE & ORDER_CLASSIFY_BILLED events): Status (cancelled => cancelled, validated => pending, accepted & shipment on process => processing, closed => completed)
+
| Orders modified in Dolibarr || The Order will be updated in Woocommerce if it is  linked to Woocommerce (the order was created by a "Woocommerce to Dolibarr sync") || In real time || <div style="color: #060">Available</div><br>Informations concerned:<br>&nbsp;&nbsp;- Order (ORDER_MODIFY & ORDER_CLOSE & ORDER_CLASSIFY_BILLED events): Status (cancelled => cancelled, validated => pending, accepted & shipment on process => processing, closed => completed)
 
|-
 
|-
 
| Shipments created (validated) in Dolibarr || Shipment will be created/modified in Woocommerce if the source order of shipment was created by a "Woocommerce to Dolibarr sync" || In real time || <div style="color: #600">NA</div>
 
| Shipments created (validated) in Dolibarr || Shipment will be created/modified in Woocommerce if the source order of shipment was created by a "Woocommerce to Dolibarr sync" || In real time || <div style="color: #600">NA</div>
Line 114: Line 114:  
|-
 
|-
 
| Stock of products  modified in Dolibarr (for any reason: the shipment is  processed, the order or invoice is validated, depending on the settings that were done in Dollibar in regards to change in the stock. The stock or inventory could be changed also manually)|| Stock is updated on Woocommerce if the product exists also in Woocommerce || In real time || <div style="color: #060">Available</div><br>Informations concerned:<br>&nbsp;&nbsp;- Stock (STOCK_MOVEMENT event): Stock quantity, In stock
 
| Stock of products  modified in Dolibarr (for any reason: the shipment is  processed, the order or invoice is validated, depending on the settings that were done in Dollibar in regards to change in the stock. The stock or inventory could be changed also manually)|| Stock is updated on Woocommerce if the product exists also in Woocommerce || In real time || <div style="color: #060">Available</div><br>Informations concerned:<br>&nbsp;&nbsp;- Stock (STOCK_MOVEMENT event): Stock quantity, In stock
|}
      
= Development =
 
= Development =
155

edits