PHPShop PriceLoader: batch processing of price lists and uploading images to an online store. Part 2

In the previous article, we talked about the possibility of batch processing of images and price-providers using the free utility PriceLoader.

Recall that the utility allows, on the basis of the price list of Excel, to create a sql file for subsequent loading it into the online store database. The sql file contains commands for updating and creating products based on such data as price, warehouse, description, article. In the new version of PriceLoader, we have added several useful options for the user.

Accounting status of goods

The new version of PHPShop PriceLoader supports accounting status of goods . Based on the imported data from the Excel file, you can select the desired action with the product:
')

• Ignore - the status ignores the presence of goods in stock and does not turn off its display on the site
• Remove from sale - with a negative value of the warehouse, the goods are removed from display in the online store
• Under the order - with a negative value of the warehouse, the goods remain in the output on the site, but it cannot be ordered, but only notified

Accounting for multiple currencies

We have done a couple of currencies of goods based on international ISO codes of currencies , which allows you to bring goods in different currencies from different price lists.

Batch Image Processing

Recall that the processed images, if there are more than one, are added to the base of the photo gallery of your online store. Now added the ability to add new images to the photo gallery and update them. In addition, images can be processed - change the size of the images for your design, impose watermark.

In order not to create an extra load on the server, due to the large number of images in one folder, you can specify the desired directory for recording the processed images.

Now you can specify in the settings how to look for images:

• Search for images whose file names correspond to the articles of the goods indicated in the corresponding fields of the data file. For example, if a product with article number “A0001” is indicated in the data file, the image file names can be: “A0001.jpg” or “A0001_1.jpg, A000_2.jpg”.
• Search for catalogs whose names correspond to product numbers. In the case of a successful search, all image files included in the found directory are considered to belong to the current product.

After processing, the resulting sql files are uploaded through the control panel of the phpMyAdmin database, or through the administrative panel of the PHPShop online store in the “Base - SQL file loading” menu. It remains only to upload the received folders with processed images on the ftp of your store to the folder / UserFiles / Image /, and the images will appear on the outer part of your store in the right products.

Thanks to PriceLoader, and even more than 20 useful utilities, you will simplify the work with the online store as much as possible, avoid routine operations. PHPShop provides these solutions absolutely free to all its users, despite the fact that similar price list analysis programs are distributed on a commercial basis.

See also: “ Downloading the price lists of suppliers to the online store through 1C ”, “ Transferring images of goods from the online store to 1C ”.