Woocommerce Items list and its First Synchronization

The WooCommerce Items List Synchronization feature allows you to import and synchronize product data between your WooCommerce store and your ERP system. This includes details such as product prices, SKUs, total sales count, and product variations. This synchronization helps connect items with your ERP system and ensures accurate inventory and order processing.

There is a Sync Woo Products button on the top of the listing table. It helps you to get the Woocommerce Products synced with your ERP system.

Sync Woo Products

This button helps you to perform a API call to your Woocommerce and retrieve all your Products list from it. Woocommerce support Product variations like colors, sizes, and other units. But from ERP it has only one stock and doesn't have different variations. If your products has more variations, You need to use the Product as Category and variations as stock items from ERP. So choose the right way to Sync, whether you want to maintain the variations as Stock or your Woo store doesn't have variations. 

Product Details

When synchronizing the items list, the following product information is retrieved and matched between WooCommerce and your ERP system:

  1. Product ID

    • Description: The unique identifier assigned to each product by WooCommerce.
    • Example: #101

  2. Product Name

    • Description: The name of the product.
    • Example: Widget A

  3. SKU (Stock Keeping Unit)

    • Description: The SKU of the product, used for inventory management.
    • Example: SKU-12345

  4. Regular Price

    • Description: The standard price of the product.
    • Example: 100.00

  5. Selling Price

    • Description: The current selling price of the product, which might include discounts.
    • Example: 90.00

  6. Total Sales Count

    • Description: The total number of units sold for the product.
    • Example: 150

Documentation for Variations Sync with ERP Screen

The Variations Sync with ERP Item screen allows users to sync WooCommerce product variations into the ERP system for the first time and manage stock updates moving forward. This tool is particularly useful for managing inventory levels across both WooCommerce and ERP efficiently.

Screen Elements Breakdown:

  1. SKU:

    • Displays the SKU (Stock Keeping Unit) of the WooCommerce product you are syncing.
    • In this case: woo-vneck-tee.

  2. Product:

    • Shows the product name and a brief description.
    • For instance: 105 - V-Neck T-Shirt.

  3. Total Variations:

    • Indicates the number of product variations.
    • Here, the total is 3, representing three different variations for this T-shirt.

  4. Cost Price:

    • A manual entry field where you can input the cost price of the item.
    • This price is used for inventory valuation and stock adjustments in the ERP system.

  5. ERP Category:

    • A dropdown that allows you to select the ERP category under which the product will be categorized.
    • If a category doesn’t exist, you can click the + button to create a new ERP category.

  6. Sync Stock Quantity:

    • A toggle switch to enable or disable stock quantity sync.
    • When enabled (Yes), the system will synchronize the current stock quantity from WooCommerce to the ERP for the first time.
    • First time usage: Helps to ensure both WooCommerce and ERP stock quantities are identical after the sync.

  7. Manual Adjustment Confirmation for Stock Update:

    • Another toggle switch that, when enabled, allows manual adjustment confirmation.
    • When enabled (Yes), it lets you manually adjust stock quantity and cost price in the ERP.
    • Usage: After the first sync, this helps you keep stock levels consistent between WooCommerce and ERP when stock is adjusted or sold.

  8. Sync All Button:

    • Pressing Sync All will trigger the initial sync process of variations and stock from WooCommerce into the ERP.
    • This button applies all of the configurations selected on the screen and initiates syncing.

Workflow:

  1. First Sync:

    • Begin by syncing product variations and stock quantities from WooCommerce to the ERP.
    • Make sure the Sync Stock Quantity toggle is set to Yes for the first sync to ensure accurate inventory levels.

  2. Post-Initial Sync:

    • After the initial sync, ERP and WooCommerce stocks can be kept in sync by enabling the Manual Adjustment Confirmation.
    • This allows updates to flow between WooCommerce and ERP for both stock loading and sales.

  3. Stock Updates:

    • Moving forward, stock adjustments in ERP (e.g., new stock added or sales made in WooCommerce) can be synced to keep both systems updated in real time.

Additional Notes:

  • Ensure the correct WooCommerce API credentials and URL are configured before syncing.
  • Regular stock syncs will keep the inventory in ERP and WooCommerce consistent and minimize stock discrepancies.

We use cookies to improve your experience and for marketing. Learn more in our privacy policy.