Skip to content

StockWooManager: Python tool for managing product stock in WooCommerce from Excel. Simplifies stock updates, developed by Eduardo Tola Losa. Connect on LinkedIn and visit GitHub.

License

Notifications You must be signed in to change notification settings

eduaero/ExcelStockManager

Repository files navigation

ExcelStockManager

StockWooManager is a versatile Python tool designed to streamline product stock management on WooCommerce directly from Excel. By offering four distinct modes of execution, StockWooManager empowers users to effortlessly handle a range of stock-related tasks with ease and efficiency. Whether you need to update prices, modify stock quantities, or synchronize product data, StockWooManager provides a simplified workflow tailored to your specific needs. Developed by Eduardo Tola Losa, StockWooManager simplifies stock updates and enhances the WooCommerce experience, bridging the gap between Excel and WooCommerce seamlessly.

Connect with Eduardo Tola Losa on LinkedIn and explore the tool's source code on GitHub to unlock a new level of efficiency in managing product stock on WooCommerce.

logo

Table of Contents

Modes of Execution

Mode 0: Retrieve information

This mode serves as the foundation for a smooth start to the stock management process. It allows users to prepare data and configurations before executing any updates.

Mode 1: Create product categories

Users can efficiently manage and update product categories using this mode. It simplifies the process of organizing and categorizing products within WooCommerce.

Mode 2: Create products

This mode focuses on updating and managing new products within WooCommerce. Users can add new products without new categories.

Mode 3 and 4: Update price and sotck values

In this mode, users can update product details such as prices, stock quantities, and other relevant information. It is designed for updating existing product information effectively.

Usage for Excel Users

Instructions and information for Excel users who want to leverage the tool without delving into the code details. It should include a step-by-step guide on how to use the tool within Excel.

Tool configuration

Before using ExcelStockManager and configuring the tool to interact with WooCommerce, you will need to generate WooCommerce API keys. These keys are essential for securely connecting and authenticating with your WooCommerce store.

To generate WooCommerce API keys, please refer to the official WooCommerce documentation. get_keys

Once you have obtained your WooCommerce API keys, ensure to include them in the sheet configuration of Excel, preferably in cells highlighted in yellow for easy identification and access during tool setup. This step is crucial for establishing a secure and seamless connection between ExcelStockManager and your WooCommerce store.

By following these instructions and integrating your WooCommerce keys into the Excel configuration, you can effectively leverage ExcelStockManager to manage your product stock on WooCommerce with efficiency and ease. paste the keyspng

[https://www.youtube.com/watch?v=j86gCX-CVwk]

Usage for Python Users

More detailed information for Python users on how the tool operates, code structure, and any modifications they can make. This could include how to integrate the tool into existing scripts.

Further developments:

  1. Include a video explaining the tool
  2. Include the issues for which there is an error when uploading a category or a product
  3. Generalize the mode 3 and 4

About

StockWooManager: Python tool for managing product stock in WooCommerce from Excel. Simplifies stock updates, developed by Eduardo Tola Losa. Connect on LinkedIn and visit GitHub.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages