CRE Loaded to Zen Cart Data Importer [support thread]

[Ajeh]

Now that you think you have things correct ...

Be sure that you have proper matching records:
products
products_description

categories
categories_description

products_to_categories (at least 1 record per product, you will have more if you have Linked Products)

Check that you have master_categories_id in each product record ... if not, run the Update master_categories_id ... NOTE: if you use Linked Products, the lowest categories_id is used for the master_categories_id ...

Run the Update Products Price Sorter ... note: run this AFTER the master_categories_id exist to set the prices correctly ...

[WooWoo]

Hello All,

I am new to zencart, and so far I really like it a lot!! I am having one issue. I have a 6.2 CRE B2B store that I need to move all the products over to zencart. I have successfully imported all of the products with the cre_import_products application, but it did not import the attributes. My existing store has 15,000 attributes (clothing store), and none of them have transferred.

that is my ONLY hangup putting this store live. Does anyone have any insight? I am not using different price groups in CRE BTW.

Thanks! !!!
--JR

[skipwater]

Have to checked out this mod in Free Software Add Ons?
CRE Loaded to Zen Cart Data Importer

[WooWoo]

Yup! That is exactly what I used to get the products imported... However, it did not import any of my attributes. Every single product I have has attributes assigned. I have around 2500 products.

It pulled ALL the information for the products (descriptions, prices, etc), except attributes - which I desperately need as it is a clothing store.
--JR

[skipwater]

If I get time over the weekend I will look into the code.

[WooWoo]

Thanks!!!

the script worked awesome, as it inserted all the products.... just missing the attributes. During the execution of the script, it did show all 15,000 attributes as imported, but it did not link them to the products.

Thanks again! It is a huge help and if this works, I am completely sold on ZenCart over CRE! That is the missing link!
--JR

[skipwater]

The zip file attached is only import_cre_products.php there was a bug in the attribute section that has been fixed. This update will be in version 1.2 that will be available in the Free Software Add On section in a couple of days.

Remember BACKUP YOUR DATA BEFORE USE.

Skip

[skipwater]

WooWoo

I have uploaded a zip file to the support thread http://www.zen-cart.com/forum/showth...324#post703324
that has the attributes fix.

Skip

Kim I don't know if you want to move this thread to the support thread?

[WooWoo]

WooWoo

I have uploaded a zip file to the support thread http://www.zen-cart.com/forum/showth...324#post703324
that has the attributes fix.

Skip

Kim I don't know if you want to move this thread to the support thread?

You guys are incredible! I will honestly say I am floored by the support and speed I have seen here so far. I have been using CRE for YEARS and MIVA before that... this is by for the best community I have seen and the quickest turn-around from a fairly complex question I have ever seen! Keep up the good work. hopefully I can contribute back soon enough!
--JR

[jen86]

Hi, I'm new to the forum.

I am importing from CRE Loaded 6.2 "Pro" to ZenCart. Everything looks good and I ran the products and customers import both with no problems.

My orders import is having problems, though, I must be doing something wrong. I have encryption enable, and I pasted my key into import_cre_orders.php as below (shown with a sample key).

$key = BhDt8rCjrdf3FoB;
$enc =base64_decode($enc);
$key = md5($key);
$iv_size = mcrypt_get_iv_size(MCRYPT_RIJNDAEL_256, MCRYPT_MODE_ECB);
$iv = mcrypt_create_iv($iv_size, MCRYPT_RAND);
$decrypttext = mcrypt_decrypt(MCRYPT_RIJNDAEL_256, $key, $enc, MCRYPT_MODE_ECB, $iv);
$decrypttext1 = trim($decrypttext);
return ($decrypttext1) ;
}

When I run the import it does not complete. It says:

Exporting Orders ...
.......................................................................................................................................................................................................200 -|
.......................................................................................................................................................................................................400 -|
.......................................................................................................................................................................................................600 -|
.......................................................................................................................................................................................................800 -|
.......................................................................................................................................................................................................1000 -|
.......................................................................................................................................................................................................1200 -|
.......................................................................................................................................................................................................1400 -|
.......................................................................................................................................................................................................1600 -|
.......................................................................................................................................................................................................1800 -|
.......................................................................................................................................................................................................2000 -|
.......................................................................................................................................................................................................2200 -|
.......................................................................................................................................................................................................2400 -|
.......................................................................................................................................................................................................2600 -|
.......................................................................................................................................................................................................2800 -|
.......................................................................................................................................................................................................3000 -|
.......................................................................................................................................................................................................3200 -|
.......................................................................................................................................................................................................3400 -|
.......................................................................................................................................................................................................3600 -|
.......................................................................................................................................................................................................3800 -|
.......................................................................................................................................................................................................4000 -|
.......................................................................................................................................................................................................4200 -|
.......................................................................................................................................................................................................4400 -|
.......................................................................................................................................................................................................4600 -|
.......................................................................................................................................................................................................4800 -|
.......................................................................................................................................................................................................5000 -|
.......................................................................................................................................................................................................5200 -|
.......................................................................................................................................................................................................5400 -|
.......................................................................................................................................................................................................5600 -|
.......................................................................................................................................................................................................5800 -|
.......................................................................................................................................................................................................6000 -|
.......................................................................................................................................................................................................6200 -|
.......................................................................................................................................................................................................6400 -|
...................................................................................

But it does not say done. When I look at the target database, the orders tables are still empty. I have almost 7000 orders so I don't know if this could be causing the problem.

Anyway, thanks for making this import tool, I prefer to use ZenCart and if I can get this step figured out with your help I will be much happier with the new software. Thank you!