No information updated after import

  • Posts: 45
  • Thank you received: 1
11 years 3 weeks ago #131167

-- url of the page with the problem -- : www.hanscoxhoveniersbedrijf.nl/index.php/online-winkel
-- HikaShop version -- : HikaShop Business 2.2.2
-- Joomla version -- : 2.5.14

There are some products in the webshop. I like to update the textfields, update prices and add new products.
After updating there is no error, but also no update.

If i remove a category from the webshop and import a new one, the old text is showing again, but the text in de CSV file is different..

Help? :(

Regards,

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
11 years 3 weeks ago #131208

Hi,

Thanks to try to use the mass actions via the menu System > Mass actions.
It allow you to update the products informations from a csv file.
Regarding the Category informations, it's not yet possible in the mass actions.

Here is the mass actions documentation:
www.hikashop.com/support/2013-08-08-00-1...massaction-form.html

The following user(s) said Thank You: rbeelen1

Please Log in or Create an account to join the conversation.

  • Posts: 45
  • Thank you received: 1
11 years 2 weeks ago #132043

A new one:
I used a cdv file to import products, prices and text. Not all prices are imported, but all products are. Only the prices on the frontpage are visible, the next level not. It is starting to irritate me that the use of the import sheet is not the easiest way to fill this database

Maybe somebody can check my file to see what's wrong? (there is dutch tekst in)

To see the store: www.hanscoxhoveniersbedrijf.nl/index.php/online-winkel

user and password are both Guest

Please help

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
11 years 2 weeks ago #132112

Your CSV is not valid. You hav main products with variants attched to them but you don't have any characteristic column with the value of each variant for each characteristic and the default value of the characteristic for each main product.
So the system is creating a product with corresponding variants but without the characteristics to link them all together. That's why it doesn't work properly.
Please create a test product with a characteristic and the variants configured and export it. You will see what you're missing compared to what you have in your CSV.

Please Log in or Create an account to join the conversation.

  • Posts: 45
  • Thank you received: 1
11 years 2 weeks ago #132351

Is there an example available with one line so I can see the difference?

Please Log in or Create an account to join the conversation.

  • Posts: 12953
  • Thank you received: 1778
11 years 2 weeks ago #132387

nicolas wrote: Please create a test product with a characteristic and the variants configured and export it. You will see what you're missing compared to what you have in your CSV.

As nicolas said, you'll be able to have a valid example by creating and exporting ONE product manually with a characteristic and the variants configured.

Please Log in or Create an account to join the conversation.

  • Posts: 45
  • Thank you received: 1
11 years 2 weeks ago #132408

1) I deleted all products in the shop, except the categories.
2) I created one product with 3 different characteristics (standaard, groot, extra groot)
3) I added a price for each characteristic
4) I checked the webshop, everything OK.
5) I exported the information to a CSV file
6) I checked the sheet and found out that the prices are changed (was 39.95 and became 3995) and saved it as a CSV file
7) I deleted the products again and did the import again.

Result: No price information was added to the shop.
I attached the sheet, could you please let me know if this information is correct? and why are the prices gone?

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
11 years 2 weeks ago #132411

Your CSV is almost correct.
You need to have the code of the main product in the product_parent_id column of each variant as it's the case in the CSV that you export.

Please Log in or Create an account to join the conversation.

  • Posts: 45
  • Thank you received: 1
11 years 2 weeks ago #132419

Please be aware that this is the way how it is exported out of the shop. If this export is wrong, something in the export goes wrong...

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
11 years 2 weeks ago #132536

Hi,

I just tried the same thing on my local, and in the csv the variants have the product_parent_id set.
I too tried with the same product_name and product_code and it's working well.

Thanks to try to download the latest version of HikaShop from our website and install it over your current version.
A fix had been made the 31/10/13 and the 02/11/13

Please Log in or Create an account to join the conversation.

  • Posts: 45
  • Thank you received: 1
11 years 1 week ago #132851

Could you please send me a copy of your file with your test? If I put the code in the column product_parent_id then the message will be: The product Riant Roze-rood boeket should have an empty value instead of the value 85170011 in the field product_parent_id as it is a main product (not a variant) and thus doesn't have any parent.

So I still don't get it..

Please Log in or Create an account to join the conversation.

  • Posts: 45
  • Thank you received: 1
11 years 1 week ago #132984

Help? please?

Please Log in or Create an account to join the conversation.

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
11 years 1 week ago #133102

Hi,

Of course, that message says that you should not add the product code in the product_parent_id column for the main product, only for the variants. Do that and it will work like I said previously.

So you say that you don't have anything in the product_parent_id column when you export the product but we can't reproduce the problem on our end. Could you provide a backend access to your website so that we can see that ?

Please Log in or Create an account to join the conversation.

  • Posts: 45
  • Thank you received: 1
11 years 1 week ago #133228

Hi Nicolas,

I attached a new file. Could you please have a quick look if this sheet is correct?

Regards,
Robert

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
11 years 1 week ago #133326

Hi,

In this csv file you have to remove the "0" in the product_parent_id column and let it empty.

The following user(s) said Thank You: rbeelen1

Please Log in or Create an account to join the conversation.

  • Posts: 45
  • Thank you received: 1
11 years 1 week ago #133451

Hi,

This looks better. Only the prices of the variations are not connected to the product. If I look manually in the article, there are no characteristics visible. Also the prices of the articles are not visible?

Please have a look at: www.hanscoxhoveniersbedrijf.nl/index.php/online-winkel

Use guest als user and guest as password

I like to give you access to the back end but not via this public forum.. ;)

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
11 years 1 week ago #133478

Hi,

And what about this csv:

File Attachment:

File Name: hcf09289.csv
File Size:14 KB

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 45
  • Thank you received: 1
11 years 1 week ago #133502

This looks ok! :) I have to look at the different sheets why this is working and the other not... ;)

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
11 years 1 week ago #133503

The price, currency, default variant were missing for the main products.
With these ones added, it seems to be better. :)

The following user(s) said Thank You: rbeelen1

Please Log in or Create an account to join the conversation.

  • Posts: 45
  • Thank you received: 1
11 years 1 week ago #133504

mmm.. okay.. It seems to have no effect on the main products it self..

Thanks. I have some more questions, but i will have first a look on the forum. It is regarding changing tekst on the buttons and frontpage.

Please Log in or Create an account to join the conversation.

Time to create page: 0.113 seconds
Powered by Kunena Forum