CRE Loaded to Zen Cart Data Importer [support thread]

[skipwater]

This script is used to import CRE Loaded 6.2 data into Zen Cart.
It runs stand alone, meaning it is independent from Zen Cart's
fuctions and settings, so it's ok to run when you are not quite setup.

WHAT IS TRANSFERRED
--------------------
PRODUCTS: (import_cre_products.php)
categories
categories_description
languages
manufactures
manufacturers_info
meta_tags_products_description
products
products_attributes
products_attributes_download
products_description
products_notifications
products_options
products_options_text
products_options_values
products_options_values_to_products_options
products_to_categories
reviews
reviews_description
salemaker_sales
specials

ORDERS: (import_cre_orders.php)
orders
-- cc number decrypted
-- cc expdate decrypted
orders_products
orders_products_attributes
orders_products_download
orders_status
orders_status_history
orders_total

CUSTOMERS: (import_cre_customers.php)
customers
-- Convert CRE customer approval codes to zen-cart codes
-- CRE codes 'Approve','Pending','Deny' default = 'Pending'
address_book
customers_info
customers_groups
customers_basket
customers_basket_attributes
customers_wishlist

Skip

[DGJOHNSON]

Hi,

First let me say, the script looks great, and I was wondering if it is possible to make some additions to your script. Here are the specs: The current specs stay the same, I would like to add the following scripts.

A: Products (ALL) Complete Profile - UPLOADED
B: Product (ALL) Sub & Main Ctoriges - UPLOADED
C: Customer Orders (ALL) - UPLOADED
D: Customers Pending Orders (ALL) - DOWNLOAD


I am going to need these files processed twice a day.

I have come up a WholeSale/DropShipper that you would love to have access to, it is not one of these sites you have to pay charge.

The site I will be presenting to you is very hard to believe, I contacted the BBB, and the Customers Site, and they assured me the information is correct, and boy they were right about the price about blowing my socks off. It has been 4 days now, and I still can not find that sock.

Well here are the Company Specs:

Web Site: http://www.dropshippingwholesalers.com/home.html
Product Line: 500,000+ Products
Product Catorgies: 53+ catories
Company WholeSales: 500+
Ebooks -FREE for Sale - $250.00+ for sale
Email Technical Support - UNLIMITED
Operating Plans: BASIC OR PLATINUM
The biggest difference of each plan is the basic platform,
The basic is just basic and the Platium plan offers a
unrestricted OS Commerce Shopping Cart .

Now for the news that WILL BLOW YOUR SOCKS OFF!!!, I have checked with the BBB, and the Company People, and they all say the pricing is correct. The plans cost with a low one time investment providing a lifetime membership with the company:

Basic Plan: $47.00

Platium Plan: $167.00

There are NO ADDITIONAL hidden charges, fees or any thing they can charge you for. The Lifetime meber provides all of the current features for free for LIFE. Boy there so much to list here it would take me better park of 2 to 3 days to type it in. Once you start to read it, you might take about 2 to 3 to pile all of the info.


Well Enjoy, oh by the way, the reason why I was wanting the additions added it would provied a total automatic website.

If you need to reach out to me, here is my info:


Looking forward hearing from you soon, if there is going to a cost factor involded with this project contact ASAP.


Sincerely,


Dave Johnson
(P) - (912) 257-4038
(C) - (912) 604-2900
(E) - dave@what is nice.com

[skipwater]

Dave

If you are having an issue with CRE to Zen I would be glad to help.

But as to modifying it to meet your needs I would suggest that you post a request in the Commercial Help Wanted section of this forum.

Skip

[setter]

Hi there,

Fantasic mod and will save us a mountain of time.

We're having a tiny problem sadly and cant find what's causing the issue.

Using import_cre_products the categories and products transfer from cre to zen with no problems at all.
All the categories appear perfectly and all the products appear in 'All Products' and 'New Products' but sadly cant get the products to display under the categories.

In admin -> categories/products all the categories are there but all saying 0 of 0 active.

On admin main page it shows: products 201 - products deactivated 0.

Could anyone please point us in the right direction.

Many thanks

[skipwater]

If you go to a product and toggle the status from Disabled to Enable and end with Enabled set. Then go back to Categories / Products what is x of x active?

Skip

[setter]

Hello,

Thanks for the quick reply.

Still sadly showing 0 of 0 active

[Ajeh]

If you look at your database tables, how many records are in:
categories
categories_description

products
products_description

products_to_categories

If you browse the products table, do you have master_categories_id that is not 0 in each of the Product records?

If you browse the products table, do you see products_price_sorter filled in for each of the Product records?

[setter]

If you look at your database tables, how many records are in:
categories
categories_description

products
products_description

products_to_categories

If you browse the products table, do you have master_categories_id that is not 0 in each of the Product records?

If you browse the products table, do you see products_price_sorter filled in for each of the Product records?

Hello there,
Thanks for that

Categories: 51
categories_descriptions: 28

products: 201
products_descriptions: 203

products_to_categories: 0

Every records for master_categories_id is 0

Every record for products_price_sorter is 0.000

[skipwater]

Categories: 51
categories_descriptions: 28

products: 201
products_descriptions: 203

products_to_categories: 0

Every records for master_categories_id is 0

Every record for products_price_sorter is 0.000

If every product is under a category there should be 201 records in product_to_categories.

In the cre to zen script it reads products_to_categories and transfers the data to products_to_categories.

When the script ran did it show a record count export and the same record count on import?

[setter]

argghhhh!!!

I found the problem. The cre site was loaded with a ep file and somehow caused a duplicate on the cre database in one of the products_options tables.

Everything works perfectly now.

Thank you both so much for your help.
Sincere apologies for wasting your time.