Is this available for download somewhere, or is this the 3 party that is for sale?

Please inform, thanks

Alvin

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.

All items have to be in FrontAccounting before you can import orders from the Zen Cart database. When adding items in FA, the Item Code of FA has to match the Product ID of Zencart.

I've done some work on this module recently and it seems to be working quite well. There are a few quirks and limitations, but is quite useful for getting your ZC orders into FA.

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

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

This thread handles your question as well.

https://frontaccounting.com/punbb/viewtopic.php?id=3272

Joe

i don't understand what u mean

i am not developer i am just accountant if you can  be more clearly that's will be nice

Joe