1

(11 replies, posted in Modules Add-on's)

If your zen cart is located at a hosting provider, you may want to check with them to find out if the DB server is accessible from the "outside". Some hosting companies may prevent access due to the shared server environment.

I also want to mention here that the zen_import module is great to import customers (it creates the customer and branch in FA). However, the orders import is limited. It only creates order headers (customer, address, order total, etc.) in the FA sales_orders table, but the line items are not imported. So, an order is partially created in the DB, but you are not able to find those orders through the UI, because of the missing line items.
I guess this is due to the fact that Zen Cart allows product attributes without specifying a unique SKU per attribute. You could include some code in the zen_orders_db.inc (if you know your way around) to include the line items in the FA sales_order_details table, but the zen cart products_model will need to exactly match the FA stock_id. If you have products with attributes in zen cart, then this will not work well.
I believe there will be a solution to add SKU by attribute in one of the next zen cart releases.

Cheers,
Richard

2

(11 replies, posted in Modules Add-on's)

Hello sameer_em2000,

I have seen the same issue. You can fix this by changing the file:
/modules/zen_import/includes/zen_orders_db.inc

line 30:
Type=MyISAM";

to
ENGINE=MyISAM";

This should work.

Cheers,
Richard

3

(3 replies, posted in Modules Add-on's)

Hi Janusz,

Thank you for looking into this. It is working now!

Thank,
Richard

4

(3 replies, posted in Modules Add-on's)

Hello,

I have been searching for an answer to activate the zen_import add-on. I have installed the latest FrontAccounting release (v2.3.11), then installed the zen_import module. It is activated for my current company.
When I go to Setup > Access Setup, ther is nowhere anything about zen_import, import, or zen cart, or anything. What did I miss?
Does this module actually work?

I also tried with FA v2.3.2 since the readme of the zen_import module says it was developed for FA v2.3.2. This didn't work either.

Thanks for any help!

Cheers,
Richard