Addon: Fast Products Import And Stocks Update From Excel, Xml With Mv Support

Dear Friends, we would like to present our addon "Fast and simple import from XLS, XLSX, XML, CSV files"

The module helps to automatize work with XLS, XLSX, XML providers price lists, all Excel formats.
What issues can this module solve?
  • Complete automatization of work with providers’ price lists and store’s stock. You do not need to check it every time whether the item is on the price’s list, convert prices into one format and upload each separately.
  • You can manage the prices on the site according to the MSRP markups compared to wholesale prices. You do need to sell goods, which are not in stock so that your clients will never be upset as for the absence the goods in provider’s stock.
  • You will always sell the goods according to the current price. The module will automatically set prices for the store, the price list of your store will always be up-to-date. You will always have the required marginality.
  • You can track any pricing changes – any new goods, price changes, stock. After every price list update, you will always have the correct information: which products are still missing from your site, which goods changed the pricing and how.
  • You can unload your content managers as well as the purchasing department. When you set up the provider once in the module, the pricing and the stock will be automatized in your store. The module supports cron-format.
  • Addon can automatically import products from XLS files into your store.

General parser settings

Categories mapping

You can map price list categories with your categories and define pairs.

General notifications
  • If the price list is unavailable, there will be a message sent to your email.
  • If after the price list upload the price changed % significantly, the notification will be sent to your email. The % can be set up.
Synonym support
Providers like to send the price lists that have a phrase – Call Us!, The Price is negotiable – instead of actual prices. Very often, the field Quantity has – Few, Specify. All these factors can be set up for every provider’s parser.
Flexible pricing rules
Full info about new products
Complete logs for work
Every price-list update is logged. You can always check:
  • Which goods are missing from the stock
  • How many products were included/excluded
  • Which goods changed the price and for how much
  • Which goods changed in quantity and for how much

Which formats does the module work with?
  • Any file in XML format. The module is able to work with any file structure, including YML files.
  • Any file in XLS, XLSX. The module can work with these price-list formats as well.
Try out demo: http://demo.retailfactory.ru/admin.php?dispatch=rf_stock_parser.manage
We can give trial version of this module and you can check it.
Full addon description available here.

Dear Friends, we have added option to run each Suppliers price list separately.

Just use comand:

path_to_php path_to_admin_script.php --dispatch=rf_stock_parser.cron --parser_id=PRICE_LIST_ID --force=1

More details available here.

looks good,

so its handles 4,52 as options combinations, but also 4.11 as product variants

looks good,

so its handles 4,52 as options combinations, but also 4.11 as product variants

Thank you.

Our addon fully supports products variations (including changing of default variation to most cheaper and available)

Options combinations is not supported (additional custom development should be required).

Dear Friends, we have released new addon version.

Now our addon supports negative margin and absolute margin.

For example, you can decrease supplier price or add fixed margin.

More information available in our manual.

Dear Friends, we have released new addon version.

Now you can define Brand feature for each storefronts for products matching based on product code and brand.
Categories mapping also now supports storefronts.

Dear Friends, we have released new addon version.

1) Now you can use XML attribuites as data. Our addon now supports all XML formats.

2) In New products section we have added search form.

You can import and search products by Product code, Brand and Category.

3) We have added Brands mapping.

We would be happy for any comment and suggestion.

Dear Friends, we are planning to release new version of our addon soon.

We will add support of CS-cart Multivendor (and Common Products addon).

Now your vendors can import prices, quantity and products by using simple interface.

If someone will be interested, please send us message via this form.

Dear Friends, we have released new addon version.

Now you can disable updating of products prices & qty for defined products.

We have added two checkboxes of the product details page in admin area:

product_settings.png

This feature available in MV version too.

If someone will be interested, please send us message via this form.

Dear Friends, we have released new addon version.

Now you can define VAT column in products import and update.

This value will be added to the product price and will be checked automatically in product page.

This feature available is in Multivendor version too, and your vendors can define VAT settings automatically.

We would be happy for any comment and suggestion.

Dear Friends, we have released new addon version.

Now you can import Descriptions and Names of products in separate columns.

You don't need to define language code - all languages will be available automatically in columns mapping.

language_names.png

We would be happy for any comment and suggestion.

Dear Friends, we have released new addon version.

Now our addon supports all types of Excel formulas.
Contents of document cell will be calculated automatically and saved in products data.
This feature is supported in all Excel versions - XLS, XLSX.

We would be happy for any comment and suggestion.

Dear Friends, we have released new addon version.

Now our addon supports Warehouses addon
Administrators and store vendors can match fields in your files with stores and pickup points during import.

We would be happy for any comment and suggestion.

Dear Friends, we have released new addon version.

Now you can update product data during import.

We would be happy for any comment and suggestion.

Dear Friends, we have released new addon version.

Now you can define negative margin in pricing rules.

We would be happy for any comment and suggestion.

Dear Friends, we have released new addon version.

We have added ability to import Buy Now Url and Seo data of products.

We would be happy for any comment and suggestion.

Dear Friends, we have released new addon version.

In new version we have added ability to import or update ANY field of cscart_products table.

We would be happy for any comment and suggestion.

If there are brands that are from several suppliers, is there any way for this add-on to be connected to products with just the Manufacturer code?

For example I have suppliers that sell many of the same brands but I get products from the one that has the best price so there is a LOT of brand overlap among them.

Dear Friends, we have released new addon version.

In new version we have added ability to select how products from supplier will be connected with products in your store:
products_connection.png

We would be happy for any comment and suggestion.

Dear Friends, we have released new addon version.

In new versions we have added ability to check structure of Excel or CSV files and prevent changes, if column definitions was changed.

columns.png

We would be happy for any comment and suggestion.