ExcelUp extension is designed to update prices and quantity of products on OpenCart from Excel price-list. It is very easy to set up and use, because it allows you to manually specify number columns, where the necessary parameters of the product. That is, for the module there is no need to make a price list according to a certain template, it will work with any one-page price list in the format xlsx, xls, csv, created in Excel.
Update products from Excel price list on OpenCart
The module will help to quickly update the prices and quantity of products by the import Excel-price. It also allows you to update only prices or only quantity of products. You can also set a markup percentage for the prices of goods in the price list.
Minimal PHP version - 7.2
Features of the ExcelUp
- independent setting of column numbers with product identifier, prices, speacials, stock (quantity);
- compare products by fields: Model or SKU or Product ID or UPC, EAN, MPN, JAN, ISBN, Location, to choose from;
- price updates;
- markup for prices;
- update specials, create specials
- markup for specials
- update stock (quantity).
You can get a personal modification of the module for your own needs - for this, contact support.
Module installation instructions:
- Upload the module in the admin panel in the "Extensions" section: "Install".
- Go to the "Extensions" section: "Extensions": "Modules" and enable the "ExcelUp: update price and quantity from Excel" module.
- Edit module. Enable the status of the module and select the necessary settings and specify the column numbers of the product parameters in the price list, save the settings.
- Edit the module again, go to the "Import" tab, download the Excel price list there and click the "Import" button.
- Check if the products have been updated.
- Bingo!
v1.6 (08/09/2022) - Remove special prices if the column is empty or has a value of 0. Added compatibility with OpenCart 4.0
v1.5 (06/06/2022) - Bug fix - no new promotions added in OpenCart 2.3.x.x.
v1.4 (10/02/2022) - SQL optimization
v1.3 (04/02/2022) - Update and create special prices. Added identification by other standard fields (UPC, EAN, MPN, JAN, etc.). Added compatibility with OpenCart 2.3.x.x.
v1.2 (10/08/2021) - Fixed price update bug, when price is formula
v1.1 (15/04/2021) - Fixed quantity update bug. When the price had a value of 0 or an empty field, this quantity was not updated.
v1.0 (03/04/2021) - Module published
You must be logged in to view the files!