csv file messing up

-- HikaShop version -- : 2.6.3
-- Joomla version -- : 3.5.1
-- PHP version -- : 5.6

Hi there

I have exported the products (About 3500) after i sat that many of them needed changes in the "price_access"
After modifing to the right ID, i import it again.
Then it messes up the category and picture links.

What can i do about it?

The change is in the "price_access" from all to ,6,7,2,8,

Import the CSV with only the product_code and price_value, price_... and price_access columns via a mass action with a CSV filter and that should do the update without touching the categories or images.

Okay.

But i do not understand that can mess up, i only have exported and changed the price_access from all.
That should not make that mess with the category and path to images.
Even if i take a csv file and use it on a similar site. it mess up whitout any changes?

Im not sure how to make the import with only the product_code and price_value, price_

I cant get it to work

I have imported the csv file with the 4 collums price_value, price_currency_id, price_min_quantity and price_access

I get this message:
Notice

The line ';;;' could not be imported Product not found
...
Message

3436 products found : 0 new products imported, 3436 invalid product code, 0 already existing products

Hi,

You need to have the product_code or product_id column in the csv file, else it can't update the values correctly.
It is not possible to have only the price columns

When i make a new csv file.
WHat do i have to use for that is a new column?

Sorry for my many questions, i am very new to using csv files and how to save them correctly.

Hi,

I'm sorry but I don't understand your question. What do you mean by "that is a new column" ? A custom product field ?

I mean, what is the seperator when saviing the csv file as a new file.

Hi,

HikaShop supports both semi colons and commas as separators. Other software might only support one or the other.