csv import set products in wrong category

  • Posts: 30
  • Thank you received: 0
10 years 3 weeks ago #177852

-- url of the page with the problem -- : supply4u.com/shop
-- HikaShop version -- : 2.3.4.starter
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.4.29
-- Browser(s) name and version -- : all common
-- Error-message(debug-mod must be tuned on) -- : cannot find product

I have a strange problem with csv import:
First I uploadet a csv file for intcartridges, what worked fine
Second I tried do to the same with printer types into main category 'Printermerken' with same structure of csv file.

Strange enough the 'Canon' printers were uploadet in the good category, the others landed in the (wrong) categorie 'Inktptaronen'
supply4u.com/shop/category/307

So, as a newbee to hika I am a bit confused :(
And one more question: can I move products from one category to another?



Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 3 weeks ago #177860

Hi,

Both CSV files definitely do not have the same structure: take.ms/dkOcE
That's where come your problem.
Make sure that you don't get extra columns in your CSV and it will work fine.

You can move products yes. Two ways:
- You can edit your products and delete the previous category and add instead the new category under the categories area (you can even have several categories)
- You can use the System>Mass actions system to change the categories of a whole bunch of products at once:
www.hikashop.com/support/support/documen...massaction-form.html

The following user(s) said Thank You: MGFM

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

  • Posts: 30
  • Thank you received: 0
10 years 2 weeks ago #178148

Hi and thnak you for your advice - now I see the diference between both.
But I have one more question:

Can I make completely my own csv file with my individuael column names or are the existing headers of each column required and must I start from a template?
You should know that I installed the demo shop content and once online I changed that to our individual structure like names and colors.

I would be very happy if you could answer me a.s.a.p. as my client is pushing me;-(
He bought now the essential version and i updated to latest version.

tks again in advance

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 2 weeks ago #178184

Hi,

The existing headers are required. You don't necessary need all of them, but if you don't use column names that HikaShop knows, it will tell you that it couldn't import the columns.

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

  • Posts: 30
  • Thank you received: 0
10 years 2 weeks ago #178304

many tks again, now it's nearly working perfect.

But: can I add extra fields and column headers and if yes, how?

greetings from holland,
Mike

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
10 years 2 weeks ago #178318

Hi,

What kind of extra field do you want to add ?
If HikaShop does not recognize a column, it will skip it.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 30
  • Thank you received: 0
10 years 2 weeks ago #178459

ok - understood - so what I can do is to change the value of a column'
by keeping the same column header or can I change that?

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
10 years 2 weeks ago #178565

Hi,

I'm not sure I understood your last question.
The CSV is an editable file, you can use LibreOffice / OpenOffice / MicrosoftOffice to open the file and add columns + values.
So I'm not sure I see the problem you got.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 30
  • Thank you received: 0
10 years 2 weeks ago #178589

Hi,
yes I know I can edit the .csv file

sorry it's not that clear

My 2 questions are
1.can I change the name of an existing column - see sceenshot dark yellow column

and/or

2. can I add a column with my own header - like column


(light yellow)

Attachments:

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
10 years 2 weeks ago #178592

Hi,

Okay I see.

The CSV import is pretty strict on the column names ; so if you rename a column that HikaShop does not know, it will ignore it.
So you can rename "product_id" column otherwise HikaShop won't be able to know the product id.

But like I told you, you can add new columns ; HikaShop would skip them (and might generate you a warning message telling you that the column "...." is unknown).

Kind regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

Time to create page: 0.095 seconds
Powered by Kunena Forum