Show Posts


Messages - castigous

Pages: 1 [2] 3
16
Thank you!

I did that last week for just a sample of 4 products, but doing that I get a CSV file which has columns that go up to [HJ] wich according to my calculations more than 200 variables/fields/columns.

I have analyzed some of them that includes dates and similar stuff that I guess are not required and that AC can fill later automatically?

That's why I've been asking for a list of the required variable/fields/columns that are INDISPENSABLE to fill to import succesfully, and the rest that would be OPTIONAL/blank.

You just mentioned the store_id variable and someone else mentioned categories --which are 2 that i can see: products_to_categories[0].category_id & products_to_categories[1].category_id both have different values which I guess the 1st one is the main category and 2nd one is a sub-category?

What If have more categories? would they go in different columns:
products_to_categories[2].category_id
products_to_categories[3].category_id
products_to_categories[4].category_id and so on?

I guess only the 1st one products_to_categories[0].category_id is indispensable and the other(s) can be updated later after I have mapped them correctly?

Any other(s) that are indispensable?

Thanks

17
Did you assign products to any category?

Do you mind sharing a short sample of your file (2-3 first lines)?

Hello and thanks for your response!!

I attach a sample (3 frist lines) file derived from the one used to do the import.

It is true that I didn't include the variable(s)/column(s) referring to categories and brands (the one I imported had about 10 columns) as I intend to insert/update this list in phases because the spreadsheet requires still some cleaning and editing, besides the mapping of the variables I had done already.

I think it would help greatly to know which variables/columns must be filled and are indispensable to make the import work, and which are optional and can be filled later as an update.

I appreciate any comments after seeing the attached sample file.

Thanks!!

18
Thanks for your input!

If you see "Created: 3560" in the report, products are created.

Do you see new products in admin?

Make sure that your cache is actually working. Go to system/cache/ and delete all files and directories.

1- I got:
Total loaded: 3560. Updated: 3560. Created: 0. Errors: 0

So I guess they were not created (although they seem to be there according to phpMyAdmin)

2- No I don't see them in admin, that's the whole point of this post.

3- I cleared the whole AC's cache, re-tried with same result, then I deactivated the AC's cache.


Thanks, but I think it would help greatly to know which variables/columns must be filled and are indispensable to make the import work, and which are optional and can be filled later as an update.


19
Hi!

Thanks for your response!

Right now I can't access the spreadsheet but is true that I didn't include the variable(s)/column(s) referring to categories and brands (the one I imported had about 10 columns) as I intend to insert/update this list in phases because the spreadsheet requires still some cleaning and editing, besides the mapping of the variables I had done already.

I think it would help greatly to know which variables/columns must be filled and are indispensable to make the import work, and which are optional and can be filled later as an update.

Later I'll try to produce those first three lines!

Thank you!!

20
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!

21
Support / Re: Import CSV from VM
« on: May 24, 2017, 03:17:33 PM »
Hi!

I followed your last suggestion from last week so I exported from AC a list of 10 products to check how isit is organized.

The thing is the resultant CSV file has more than 510 columns of variables  :o :-X for each product (up to column ACS on Libreoffice), so I find quite overwhelming to know what of those variables are the ones I need to fill and-or replace from the list exported in VirtueMart.

Do you have any other suggestions?

Also I have tried to contact AbanteCart professional support about 3 times since more than a week ago, so I fill the form but so far haven´t received any response.

Should I give up with this project?  :-[ :-\ :'(

22
Support / Re: Country localization issues
« on: May 24, 2017, 12:43:20 PM »
Hi Ilegrand and thanks for your input.

ZIP or postal codes exist but they are not needed for sending/receiving anything which means that most of the population (99%) don´t know anything about it even for their own residence ZIP --the carriers here never asks for it and the address is good enough.

Some people know that a ZIP of five numbers can be used (usually 00000) but most people don't know it so they could get stuck at the checkout page for not knowing this info that is not relevant here but in the end would be unable to complete the order.

Now the 2nd part of what you've said intrigues me. You mean put in the translation something like:
Zip code (Ingrese 00000 si no está seguro) or in english: Zip code (Enter 00000 if not sure).

Maybe that could work, I'll try it!

Thanks!




23
Support / Re: Tax rule not being used/calculated at Checkout
« on: May 24, 2017, 12:31:16 PM »
Thanks!

I checked all of it and the problem was that the Location Zones were not defined. Once I defined them, the checkout calculated it at checkout but not the way it was supposed to.

I mean in my country all receipts work a bit different. If I put x price for a product (as is shown in the product page), that's is supposed the final price including taxes --I mean the receipt is supposed to show three things:
1- The price without the tax
2- The tax (20%)
3- The total that is the sum of 1&2

For example if the description page says that the price is $120, then at checkout and later in the receipt it should be described as:
Subtotal=100
Tax=20
Total=120

But AbanteCart applies the tax after what should be considered as the total price and obviously that is not what we need in our country.

Is there a way to work around this?

Thanks!

24
Support / Re: Country localization issues
« on: May 24, 2017, 04:29:02 AM »
Thanks!

It fills most of the address info but fails to fill the ZIP code which is the one would confuse/trip most people here.

Can it get somehow eliminated from being asked the ZIP? Or at least auto-fill it somehow?

25
Support / Re: "fallback" banner not updating
« on: May 23, 2017, 01:35:58 PM »
Thanks!

I read the banners, blocks & layouts documentation pages and I think I've got it at least partially.

I get that banners are only supposed to display 1 image which becomes a clickable image associated with an URL.

I get that to have a slideshow I have to create or modify 1 block that selects all the static banners I just described.

I get that I have to modify the layout of the Home page so it includes the block I just described.

Am i getting something wrong at this point?

I wanna see the functionality as it appears on the original AbanteCart Home Page (before making modifications to AbanteCart) that works as a slideshow that alternate between images and even has a nice roll on effect from above.

I have used 2 types of "block wrapper (appearance)" settings: FlexSlider & OneByOne but none of this show all the static banners I created and selected (it only shows 1 of these I selected).

I hope is not too confusing but it is kinda hard to explain without showing.

Thanks

26
Support / Re: Country localization issues
« on: May 23, 2017, 12:33:49 PM »
Thank you!

We only sell inside the country so what I meant is that when in the Checkout stage, we would like this shipping info to be filled ONLY by the info that the customer put when creating the account and is in the client´s account data.

If that´s not possible and checkout page absolutely needs to ask again for this info anyway, we would like it that at least it wouldn´t ask for ZIP as that is something that addresses in my country don´t have and carrier companies don´t ask for.
Asking for it could create some confusion in the customer as he/she wouldn´t be sure how to fill this info appropriately.

Maybe could there be a way to autofill the ZIP info with zeros? and the checkout page could have this already filled and maybe greyed-out?

Thanks!

27
Support / Re: Import CSV from VM
« on: May 23, 2017, 12:11:48 PM »
Hi!

Thanks for your answer but still having issues.

I figured that to insert the products I have to import the manufacturers first, because to insert the products the list of manufacturers must be set up already --also as a test of importing a smaller CSV with just one variable.

So I downloaded all CSV files on the documentation link, opened the one that is about inserting manufacturers and followed all settings within the documentation page.

At some attempts I got some errors but finally I got a message:

Total loaded: 110. Updated: 0. Created: 110. Errors: 0

But if I go to Catalog->Manufacturers on AbanteCart I still see no changes. I see the list of manufacturers that the installation of AC creates (Gucci,Bvlgari...).

Is it a cache issue or maybe some permissions somewhere?

I attach the 2 CSV files (with and without quoted text) that gave me the message I mentioned which seemed to indicate all was alright.

EDIT: I don't see the attached files without being logged in, so next I put the first 5 lines for each file I attempted with:

1- manufacturers_export_2.csv:

action   manufacturers.manufacturer_id
insert   2k Games
insert   2k Sports
insert   505 Games
insert   Activision
...


2- manufacturers_export_2_noquotedtext.csv:

action   manufacturers.manufacturer_id
insert   "2k Games"
insert   "2k Sports"
insert   "505 Games"
insert   "Activision"
...


Any suggestion(s) are *very* appreciated, especially because the CSV file for products is going to be much longer and if I´m stuck with this, I don´t wanna imagine when working that products list.

Also for this question I made before:

Quote
I have some custom variables for all product (like say for example color, material, etc). How could I map this variables to something that AbanteCart would understand?

I can't export a csv from AC with these custom variables as so far there is no product that has this custom variables, which begs the question if there is a way to add these variables manually inside AC in the first place? --maybe as a category? or as a tag?

Thanks!

28
Support / Re: Import CSV from VM
« on: May 19, 2017, 03:11:06 PM »
Thanks a lot!!

This page is very detailed and is a great reference, which I know I´m using in tee export stage.

But I have some custom variables for all product (like say for example color, material, etc). How could I map this variables to something that AbanteCart would understand?

Also for all those variables with a possible value of ON/OFF (for example "Requires Shipping" which I guess is named "products.ship_individually" in the database), I would guess that they should have a value of 1(ON) or 0(OFF).
But in one of example csv file, I see values of "0.0000" for this variable. What would be the correct value to import?

Also for the variables ended with a "class_id" (for example "products.tax_class_id"), should I include this variable on a column in the CSV file? If that´s correct how can I know or discover what value should I assign to them?

Thanks!


29
Hi!

Could please someone with experience try and answer this?

Sorry to have this many questions. After experience with AbanteCart I hope to be become less annoying ;D

Thanks

30
Hi!

Actually my question could be more general. Is there a way to make the adjustment to 1 variable in many/all the products in (something close to) 1 step?

The idea is to try and avoid to be forced to edit the products one by one if this setting is going to be the same in all --for example "Maximum Quantity" to be set 3 which could be a typical case.

Thanks!

Pages: 1 [2] 3

Database Error

Please try again. If you come back to this error screen, report the error to an administrator.