Hi!

Since I haven't had an answer to my topic since last friday --maybe because I added too many sub-topics to it in the late questions. I decided to post in separate topics.

I managed to read again the documentation (at http://docs.abantecart.com/pages/tools/import.html#Example4:insert) about importing and found out that I was missing a lot columns when trying to import the references for the images of each product.

Turns out that for each image there are about 8 columns needed to include in the CSV file.

resource_map[0].resource_id              = leave empty
resource_map[0].object_name            = products
resource_library[0][0].type_id            = 1
resource_descriptions[0][0][0].language_id      = 1  (the id of installed language)
resource_descriptions[0][0][0].name             =    anyname (usually imagefile name)
resource_descriptions[0][0][0].title            =    leave empty or fill if you need title
resource_descriptions[0][0][0].description      =    leave empty or fill if you need description for the resource
resource_descriptions[0][0][0].resource_path    =    somefolder/product_image_1.jpg

So I added the correct 40 columns --differing in their ([0][0][0]) numbering ([1][0][0], [2][0][0]... and so on) for up to 5 images max.

I split into 100-rows CSV files in order to avoid a Gateway error due to a big files with too much data, but even with this small file, when uploading the CSV file I got this error:

"
Total loaded: 6. Updated: 0. Created: 0. Errors: 6
There are some errors. Show details
Insert data error for products SQL Error: Duplicate entry '127' for key 'PRIMARY'
Error No: 1062
SQL: INSERT INTO `abc_products` SET `product_id` = '127'
Missing special relation ID product_id for insert action in table resource_map. Skipping.
Missing special relation ID product_id for insert action in table resource_map. Skipping.
Missing special relation ID product_id for insert action in table resource_map. Skipping.
Missing special relation ID product_id for insert action in table resource_map. Skipping.
Missing special relation ID product_id for insert action in table resource_map. Skipping.
"

I did these CSV files following the instructions on the documentation page which all required columns which are included so I don't know what's going on? Is this a bug at the import?

Please somebody help as I'mpretty stuck at the moment for this problem.

I attach sample of the CSV files.

Thanks!

Hi!

I've worked extensively on our list of products so it would be readable by AbanteCart (all folollowing the documentation on  and the CSV that are there as examples). I also checked that the [product_id] column was empty for every product.

Now after many hours, I did the procedure and the message AC was that the process was completed succesfully:
Total loaded: 3560. Updated: 0. Created: 3560. Errors: 0

But I return to the products list and I see no update, it's the same short old list.

So I eliminated the first column that says [action] and has [insert] in all the the cells below so I could try it as an update.

It also tells me it was OK:
Total loaded: 3560. Updated: 3560. Created: 0. Errors: 0

But the products still don't appear.

I checked the database with PhpMyAdmin and it seems they're there (table: abc_products) so I don't get get what is happening and I' getting frustrated after so many hours.

I cleaned AC's cache (System/Cache) and even deactivated it on the options.

Please help! I'm on a deadline and the professional support of AC is not even contacting after repeated attempts.

I don't know what to to do

Thanks!

Hi!

Our old webshop used Joomla-VirtueMart so we are naturally trying to import the data from it to our new AbanteCart store.

Since this is not one of the software supported by the Migration Tool I think we could use a joomla extension that we have tha can export all VM fields in a CSV file.

But in order to do that I think we would need to know in what are the fields required and if there is a need of fields translations (for example product in VM should be imported as product_name in AbanteCart), and which format should the CSV have (like header, delimiters, etc)

Any guidance would be very appreciated!

Thanks!

Hi!

Right now I only have Cash on Delivery as a payment option, but I keep getting a message Error: Payment method required!. Why it cannot accept this way of "payment"? How can I fix this?

Hi!

I created a tax rule that should apply for every product in the catalogue. I have too many products with a tax class value of Taxable Goods. Is there a way to assign all this products my new Tax class instead of Taxable Goods all at the same time and not just by editing them one by one?

Thanks!

Hi!

As a novice in AbanteCart I´m implementing an online store located in our current region of Colombia in Latin-America.

Although many thing are going good, I have had a series of setbacks which are impeding the successful implementation of the store.

For this reason I have some questions for anyone that can gracefully answer:

-1- How to correct or complete the partial translations on the frontend of the site? I mean some pages/parts of pages in the frontend still display English instead of the Spanish language I chose as default. Is there a way to show the whole site in Spanish mandatorily and no option of changing to/from English?

-2- How to create different permissions for Sales Managers especially? I mean there is a page in the documentation at URL: docs.abantecart.com/pages/users/user_permissions.html that gives the example of a "Data Entry" operator. Is there a similar list for a "Sales/Order" operator or manager?

-3- Localisation. I have already activated the correct settings (Country, Zones, currency) for my country and deactivated the ones that are for USA or anywhere else in the world. Spite of that, on the checkout page the customer still has to choose some things that I assumed were already chosen for him being that they are deactivated on the backend of AbanteCart:

- He/she has to choose Country / State

- He/she has to choose a ZIP or postal code –which we don´t generally manage in Colombia and there is almost nobody here who knows their own ZIP.

-4- I created a tax rule that should apply for every product in the catalogue. I have too many products with a tax class value of Taxable Goods. Is there a way to assign all this products my new Tax class instead of Taxable Goods all at the same time and not just one by one?

-5- As a test I assigned this tax class rule (which is a percentage) to one item and tried (as a customer) to buy this item but the tax is not shown or calculated at any point in the Cart. The total it gives the cart gives me is the same price of the product.

-6- Right now I only have Cash on Delivery as a payment option, but I keep getting a message Error: Payment method required!. Why it cannot accept this way of "payment"?

Hopefully someone can help clear this questions/issues. As a novice of AbanteCart, I like it a lot and see a bright future for it although right is presenting me some challenges.