ExcelUp: update price and quantity from Excel for OpenCart
Last Update:10/02/2022Module version:1.4Module format:ocmod.zipModification:noOpenCart:2.x - 3.xOcStore:2.x - 3.xPHP:5.x - 7.xionCube Loader:noSupport:noLicense:CC BY-ND 3.0
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.
The module will help to quickly update the prices and quantity of products by importing 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 module:
- 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).
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.
- OpenCart: 2.3.x.x, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52