WooCommerce Integration

Owned by Herman Wijoyo
Last updated: Sept 03, 2024
6 min read

Readysell integrated with WooCommerce web platform for upload Products (include stock quantity, sell price and web category).

 

Product Integrations

Product model :
1. Normal product :
In website, this product would be shown as Product with $xxx from Default Price List

  • WooCommerce Product ID would be stored in Custom Field 1 value (leave this blank for new product created)

2. Product using Custom Fields for Grouping sizes :
Best way to use this model is when 2 Products as different sizes (i.e. Product A is detergent 5L bottle and Product B is Product A in 25L bottle).

In website, this product would be shown as Product A with size 5L $xxx and size 25L $yyy (all sell prices from Default Price List)

  • WooCommerce Product ID would be stored in Custom Field 1 value for parent product (leave this blank for new prduct created)

  • WooCommerce Product Variant ID would be stored in Custom Field 1 (leave this blank for new product created)
    *for parent Product, this value would be stored in table Data Mapping

  • Custom Field 2 value is Product ID parent as group (this value would be replaced with WooCommerce parent Product ID) i.e. put Product A Product ID in both Product A and B Custom Field 2

  • Custom Field 3 value is text that would be shown in website for size, i.e. 5L in Product A and 25L in product B Custom Field 3

  • Examples :
    Parent Product :

     

    Other product :

Website :

3. Product using Kit for Grouping options :

Best way to use this model is when 1 Product has multiple options to sell, i.e. Product C is glove that can be sold as 1 sleeve with 1000 gloves, as 1 box with 20 sleeves, and as 1 carton with 10 boxes

In website, this product would be shown as Product C with options Sleeve $xxx , Box $yyy , Carton $zzz (all sell prices from Default Price List)

  • WooCommerce Product ID would be stored in Custom Field 1 value for parent product (leave this blank for new product created)

  • WooCommerce Product Variant ID would be stored in Custom Field 1 (leave this blank for new product created)
    *for parent Product, this value would be stored in table Data Mapping

  • Setup :
    a. Product C $10 sell 1 sleeve with 1000 gloves : Product Unit sell “1000 / sleeve”

b. Create Non Stock Product D $20 sell 1 box with 20 sleeves : Product Unit sell “1 / Box”

c. Set Product D with Kit component Product C with 20 qty

d. Create Non Stock Product E $30 sell 1 cartoon with 10 boxes : Product Unit sell “1 / Carton”

e. Set Product E with Kit component Product C with 200 qty (calculation : 1 carton=10 boxes; 1 box=20 sleeves; 1 carton=200 sleeves)

  • Examples :
    Product Stock

Product Non Stock :

Product Non Stock :

Website :

 

Task : WooCommerce Upload
Parameters :

API Key, Secret & Url : Get from WooCommerce

EnableAttSyncDownload & AttSyncMax : to download all attributes from WooCommerce (Size, Option, style, etc) and Max count of Attributes to be downloaded (or sync)

EnableWebCatSyncDownload & WebCatSyncMax : to download all web categories from WooCommerce and Max count of Web Categories to be downloaded (or sync)

EnableWebCatUpload : to upload any new web category when created from Readysell ERP or existing web category that changed in Readysell

EnableProductUpload : to upload any new product when created from Readysell ERP or existing product that changed in Readysell (stock / price / text changed)

SiteID : Readysell only support single site integration to WooCommerce

*Check this link to create Product Sale price : Product Sale Price


Order integrations

A task will download any order created in WooCommerce and generate an order in Readysell ERP.

 

Task : WooCommerce Download
Parameters :
API Key, Secret & Url : Get from WooCommerce

Localhost Username, Localhost Password & BypassSsl : Readysell username password for web service role

Card Type Code Default : Default card type when customer created from order if not exists in Readysell database (searched by email address in Card Contacts)

Tender ID Payment : Default Tender ID for any payment in WooCommerce orders

Shipping Product ID : Default product for shipping in WooCommerce orders

Order Prefix : any order created in Readysell will start with this prefix

SiteID : Readysell only support single site integration to WooCommerce

OrderID : [optional] manual override of order ID to be retrieved from WooCommerce

 

Examples :

  1. Product as Custom Fields Group model

2. Product as Kit Group model

 

with customer delivery / shipping details :


Readysell can update to WooCommerce order status to complete when Readysell Invoice posted.

Readysell can update to WooCommerce order status to Refunded / Complete when Readysell order Cancelled (including request to WooCommerce to do the refund to customers)
see here - Woo Commerce Order Updates

Readysell download the orders from WooCommerce with Status :
- Processing : Readysell create new sale order if not existed

-Refunded : Readysell cancel existing sale order if existed (this is Full Refund from WooCommerce)

-Cancelled : Ignored

-Processing (but partial refund) : ignored