import problem

  • Posts: 11
  • Thank you received: 0
9 years 10 months ago #184901

Hello, I have a question.
I try to import some products wits subproducts in Hikashop and i have a few questions:
* I don't know whats going wrong but i don,t see the subproducts on the frontpage
* The next question is.. is it possible to import the productprice included vat? and witch table do i need in the csv file ?
* Witch table do i need to import the name of the vendor?

I hope someone can help me

File Attachment:

File Name: hika.csv
File Size:11 KB

Attachments:
Last edit: 9 years 10 months ago by HansIT.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 10 months ago #184929

Hi,

1. You also need to have one column for each characteristic of the product with the value of each characteristic for each variant but also for the main product in order to set the default value of the characteristic on the product page.
Without that data, the import system doesn't which variant is for which characteristic value and thus you don't get any characteristic on your products and the variants are just ignored.
I invite you to first configure a product like you want via the interface and then do a CSV export as we recommend in our CSV import documentation. That will give you a full example, including the characteristics columns.

2. Yes. In that case, you want to use the column price_value_with_tax instead of price_value.

3. There is no such capability. The system can only import the id of the vendors. So instead of the name, enter the id of the vendors in the product_vendor_id column of your CSV. You can find it on the vendors listing of HikaMarket.

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

  • Posts: 11
  • Thank you received: 0
9 years 10 months ago #184958

Thanx.. you helped me a bit further but i saw on the website:
Similarily to the images and files column, you can have a related column where you can write product_code values of other products already inserted or placed before in the file. These products will be linked as related products to the main product.
For example:
product_code,product_name,related
my_product_1,My first product,""
my_product_2,My second product,""
my_product_3,My third product,"my_product_1,my_product_2"

This will add three products and the third one will have the two others as related products.

What i want is only one product with serveral related products...
Is that possible?

Please look at the website jvd.nl that data must be imported to hikashop
Thanx

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 10 months ago #184999

Hi,

I didn't see any related products on that website. What I saw there was product variants/characteristics.
So the section you want to read in the import documentation ( www.hikashop.com/support/support/documen...hikashop-import.html ) is the one titled "Importing products with variants"

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

  • Posts: 36
  • Thank you received: 5
9 years 10 months ago #185310

Hi,

I may be off line on this. But, I created a csv file for another user that works. I modified HansIT file to show how I created the header for "Hikashop" import.

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

  • Posts: 11
  • Thank you received: 0
9 years 10 months ago #185312

Please can you send your modified file also to me?

Greetz Hans

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

  • Posts: 36
  • Thank you received: 5
9 years 10 months ago #185313

Hi,

Sorry file did not attach. I'll have to try again latter. On my way out.

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

  • Posts: 11
  • Thank you received: 0
9 years 10 months ago #185463

Please don't forget me :-)

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

  • Posts: 36
  • Thank you received: 5
9 years 10 months ago #185466

Hi,

I did not forget.
I'm having problem with attaching the file.

File Attachment:

File Name: hika.csv
File Size:0 KB

Attachments:
The following user(s) said Thank You: HansIT

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

  • Posts: 11
  • Thank you received: 0
9 years 10 months ago #185470

Please who can tell me what i'm doing wrong.
I made a csv importfile and when i import the list, the products and the variants are visible in the backend but in the frontend i see only the main product.
Please help!!!


File Attachment:

File Name: hika-nieuw.csv
File Size:2 KB

Attachments:

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

  • Posts: 36
  • Thank you received: 5
9 years 10 months ago #185476

Hi,

Here's a redacted copy of my file.
I load this thru "Joomla" back end with a extension to "Hikashop".
This format allowed me to upload over 2000 products.
Of course your situation may different than mine.

File Attachment:

File Name: Test.csv
File Size:0 KB

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 10 months ago #185477

Hi,

@HansIT : your problem is that you didn't enter any value for the main product in the characteristics columns. You need to put the value that you want as default when you arrive on the product page.
That's what also tells the system which characteristics should be added to the product so that's why it doesn't work.
This is a point clearly mentioned in the documentation I gave.

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

  • Posts: 11
  • Thank you received: 0
9 years 10 months ago #185479

Sorry Nicolas... i realy don't know what you mean
Can you please let me see what i must do in the file attached i my previous message

Thanx

Last edit: 9 years 10 months ago by HansIT.

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

  • Posts: 13201
  • Thank you received: 2322
9 years 10 months ago #185519

Hi,

In this example from the documentation:

product_code,product_parent_id,size
main_product,,big
first_variant,main_product,big
second_variant,main_product,small


You can see that the "main_product" has two variants, "first_variant" and "second_variant".
These variant are based on the "size" characteristic, their values are "big" and "small".

The main product need to have a default variant value set, so in this example for the "main_product" you have to set a default size, in the example the size used is big.

main_product,,big

The following user(s) said Thank You: HansIT

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

  • Posts: 11
  • Thank you received: 0
9 years 10 months ago #185582

Top!!! Solved

Thanx for your support!!!

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

  • Posts: 11
  • Thank you received: 0
9 years 10 months ago #185623

Hello

Is it possible to make automaticly vendors and options during the importprocedure and when the answer is yes..... how to do that ( witch column header do i need??)

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

  • Posts: 36
  • Thank you received: 5
9 years 10 months ago #185640

Hi,

Would it be possible for you to attach a redacted copy of your file?
I too am still learning.

Thanks.

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

  • Posts: 11
  • Thank you received: 0
9 years 10 months ago #185645

He Charles... sure
Catch it :-)

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

  • Posts: 11
  • Thank you received: 0
9 years 10 months ago #185646

sorry

Here it is

File Attachment:

File Name: hikashop-test.csv
File Size:2 KB

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 10 months ago #185643

Hi,

Yes. You can add a product_vendor_id column in the CSV and set the id of the vendor in HikaMarket for each product and that way it will link the imported product with the vendor in HikaMarket.
This of course requires that the vendors are already in HikaMarket.

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

Time to create page: 0.122 seconds
Powered by Kunena Forum