X-Cart forums

[BCSE]

We have an exciting new Prerelease for our new Product Importer/Updater PRO. Presale! Buy now and save $50! Target release date is August 1, 2008

This module so far is running super fast. We have done some beta testing with 160,000 products. It is importing these in 33 minutes! Our target is to be 50 products or more per second and we are currently doing imports 80 per second!! These tests though do not include the time it would take to download images if images do not exist.

This new product should do anything and everything you need for product importing and product updating. No more having to conform to a certain file standard to import! Our importer will virtually take any text file format and allow you to use it to import and update your products. You can even cron the system to auto pull down a file from a supplier and have it auto update your products for you.

Also you can import ALL of your product information in this one file. This includes all image information (multiple detailed images for each product, thumbnail, main image), wholesale prices, extra fields, product options, product variants, most 3rd party information and most custom columns in the products table.

We are also supporting most 3rd party modules!

Product Importer Pro support the following standard data formats including custom formats:

* Comma Separated Values (CSV)
* XML
* Tab Delimited File
* String Delimited File
* Regular Expression Delimited File
* Column Delimited File
* Other (custom delimited file)

You can find more information here:
http://www.bcsengineering.com/store/customer/product.php?productid=278&MMCF_xfPIP

Please feel free to ask questions here or email us at support with any questions.

Thank you!

Carrie

[Thedae2k]

Wow..that looks really useful Carrie. Can you add new products through it? Also, can you choose to update products from a single manufacturer only?

[BCSE]

Yes,

The whole purpose is to make it much easier to mass add products and mass update products. You can choose to import or update only sets of products at a time if you like. So yes you could upload a set from just a specific manufacturer.

You can upload as little or as much information as you want. The only requirements is if it is a new product, you must upload the minimum data that X-cart requires for a product to be added in the admin (so sku, product name, descriptions, etc). However on updating all you have to provide is the SKU and anything you want to update. You don't have to feed it all the fields during updating if you do not want to update those fields.

You can also add AND update products in one file feed. If a sku exists, the system auto updates that product with the info provided in the file feed you give it, if it does not exist, it will add that product.

Let me know if you have more questions!

Thanks,

Carrie

[Prest0]

Carrie,

Has this been released yet? I pre-ordered back in July and I know it was running a little behind schedule. We really need to get this set up to bring in a supplier in time for Halloween sales.

-Preston

[BCSE]

Yes we were doing some final testing last week. We should have the first release later today or tomorrow. We've done some silent releasing with the testing so we are at about 1.0.3 or 1.0.4 I believe.

We'll update you later today or early tomorrow.

Thank you!

Carrie

[BCSE]

Just an update that we will be doing an export of this module tonight to have it ready to ship out tomorrow to those that ordered it without configuration.

Thanks,

Carrie

[intel352]

I'm curious, do you allow linking of tables in the X-Cart database for data import?

For example, while the old CDSEO mod and older versions of XCSEO Pro added a new column to the xcart_products table, both CDSEO Pro and XCSEO Pro currently have their URL data stored in a separate table (which is central to Category, Product, Manufacturer, and Static Page urls).

So, with your product, is it possible to construct a JOIN between xcart_products and xcart_phpss_xcseo to update the XCSEO fields related to the product that is being updated?


If not, that's fine, but if so, then that's pretty damn cool

[BCSE]

Originally Posted by intel352

I'm curious, do you allow linking of tables in the X-Cart database for data import?

For example, while the old CDSEO mod and older versions of XCSEO Pro added a new column to the xcart_products table, both CDSEO Pro and XCSEO Pro currently have their URL data stored in a separate table (which is central to Category, Product, Manufacturer, and Static Page urls).

So, with your product, is it possible to construct a JOIN between xcart_products and xcart_phpss_xcseo to update the XCSEO fields related to the product that is being updated?


If not, that's fine, but if so, then that's pretty damn cool

For right now, it does not allow mapping to *new* tables such as this. It will see new columns in the products table, but not new sub-product tables that are non-xcart standard.

However. We do like to be very compatible with the popular 3rd party modules out there. So we certainly can look at making it compatible with yours and Jon's modules as it would be very convenient for our customers. Drop us an email with any details we need to know and we can schedule it for a future release or possibly an addon to the module.

Anyone seeing this wanting their Product Importer Pro compatible with either CDSEO Pro or XCSEO Pro please email us at "support" or use our contact us form. The more requests we get usually the faster we can put changes into the code.

Thanks,

Carrie

P.S. Those waiting for it the module that did not choose the configure option will be receiving it today. We've put some more features in it and wanted to get that in there before releasing. So please contact us if you do not see the zip come in today (incase it goes to your spam folder, etc).

[Paiger]

Hi guys,

We are in the process of moving to Xcart 4.2 purely because one of our suppliers has thousands of products available for drop ship as well as the usual lines we buy and stock our selves.

So, as an Xcart noob could you tell me if the following is possible with your software? We set up a seperate provider in our store and load on the drop ship products. We then need some software which will poll a file over ftp, I think every 10 minutes as they want stock levels to be highly accurate to avoid over-selling. There are a lot of stores accessing this inventory so it's important that all those stores have accurate stock levels.

So, will your product be able to do regular updates from a stock file stored on a remote server somewhere at the other end of the UK?

Thanks

[BCSE]

Yes it will pull a file over FTP to update the products. It can update how ever often as you like. The only thing you need to keep in mind is if its a huge number of products, you'll want the update to be done before it runs again. It does have some locking with it so that you cannot run it too often and stomp on itself. You'll just have to keep in mind your data. If it's like 100,000 products, it will take longer to update than a few thousand. Or if it's a complicated update rather than just a simple price, quantity update then it will take more time.

Feel free to email us a sample file that you want to update with and we can evaluate how easy it will be to integrate. Some more complicated files will require some php coding to translate what you get from your supplier into something X-cart can use. Some common fields that have php programming done:
1. price from supplier needs to be marked up
2. Categories from supplier are not the categories you want to display your products in.

Thank you,

Carrie

Originally Posted by Paiger

Hi guys,

We are in the process of moving to Xcart 4.2 purely because one of our suppliers has thousands of products available for drop ship as well as the usual lines we buy and stock our selves.

So, as an Xcart noob could you tell me if the following is possible with your software? We set up a seperate provider in our store and load on the drop ship products. We then need some software which will poll a file over ftp, I think every 10 minutes as they want stock levels to be highly accurate to avoid over-selling. There are a lot of stores accessing this inventory so it's important that all those stores have accurate stock levels.

So, will your product be able to do regular updates from a stock file stored on a remote server somewhere at the other end of the UK?

Thanks