Import products from RedShop

  • Posts: 14
  • Thank you received: 0
13 years 7 months ago #12697

Hi Nicolas,

I've been testing your software for a while and I'm satisfied.

Currently I use a live shop on redshop which is very unstable.
I would like to switch to Hika Business version and I need to import over 3000 products and more than 170 categories.

I haven't tested if it's working with sh404sef yet...(that I use for SEO). It is important to keep the same links for products as they get "juice" already.

Thank you,
Marius

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 7 months ago #12699

Hi,

You need to see how you can export the products information as a CSV (or maybe you already have a CSV ?) from redShop. Then, you can use the import screen to add them automatically (after changing a bit the header of the CSV ):
www.hikashop.com/en/support/documentatio...hikashop-import.html

HikaShop works with sh404sef. Now, the structure of the links is different between redshop and hikashop so they won't be the same.

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

  • Posts: 14
  • Thank you received: 0
13 years 7 months ago #12773

I got this error when trying to import...

Fatal error: Maximum function nesting level of '100' reached, aborting! in C:\wamp\www\administrator\components\com_hikashop\helpers\import.php on line 320

Thanks.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 7 months ago #12776

Could you give the first few lines of your CSV file ?

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

  • Posts: 14
  • Thank you received: 0
13 years 7 months ago #12778

For now there was a test...look the first 3 lines:

I have to adjust them to import correctly, but which "labels" can be modified and imported?

"product_id,"product_parent_id","manufacturer_id","supplier_id","product_on_sale","product_special","product_download","product_template","product_name","product_price","discount_price","discount_stratdate","discount_enddate","product_number","product_type","product_s_desc","product_desc","product_volume","product_tax_id","published","product_thumb_image","product_full_image","publish_date","update_date","visited","metakey","metadesc","metalanguage_setting","metarobot_info","pagetitle","pageheading","sef_url","cat_in_sefurl","weight","expired","not_for_sale","use_discount_calc","discount_calc_method","min_order_product_quantity","attribute_set_id","product_length","product_height","product_width","product_diameter","product_availability_date","use_range","product_tax_group_id","product_download_days","product_download_limit","product_download_clock","product_download_clock_min","product_download_infinite","product_back_full_image","product_back_thumb_image","product_preview_image","product_preview_back_image","checked_out","checked_out_time","max_order_product_quantity","accountgroup_id",sitepath,category_id,category_name,accessory_products,product_stock,images,images_order,images_alternattext,video,video_order,video_alternattext,document,document_order,document_alternattext,download,download_order,download_alternattext
7949,"0","294","0","0","0","0","9","Fibre si Plante","39","0","0","0","3C001","product","3 CHENES Fibre si plante va aduce in fiecare zi binefacerile diferitelor fibre pentru a va ajuta sa slabiti. Taie senzatia de foame in mod natural, blocheaza grasimile si zaharurile. Contine pectina de mar.","<p> <span style='font-weight:bold'>Actiune:</span> Consumarea de fibre este o masura dietetica ideala pentru asigurarea greutatii proprii si optimizarea functionarii tubului digestiv. Cu toate acestea, obiceiuriel alimentare dezechilibrate si prea bogate, nu raspund mereu la aceasta recomandare nutritionala. </p> <p> 3 CHENES Fibre si plante va aduce in fiecare zi binefacerile diferitelor fibre pentru a va ajuta sa slabiti.  </p> <p>3 CHENES Fibre si plante asociaza in mod egal virtutiile depurative ale ridichii negre si virtutile diuretice ale papadiei pentru favorizarea eliminarii toxinelor si va ajuta organismul sa se simta bine. </p> <p> <span style='font-weight:bold'>Compozitie:</span> Fibra de ovaz (30%), guma de acacia (30%), extract uscat de ridiche neagra (10%), extract uscat de papadie  (10%), Fructo-oligozaharide (10%), pectina de mar (9%), guma guar (1%). </p> <p> <span style='font-weight:bold'>Continut:</span> 14 pliculete </p> <p> <span style='font-weight:bold'>Mod de administrare:</span> Cu un sfert de ora inainte de masa principala, diluati un pliculet intr-un pahar cu apa si amestecati bine inainte de a bea. </p>","0","0","0","","282de4ac4b760bbb6ea8a818511c2b50.png","0000-00-00 00:00:00","2011-03-30 09:21:35","0","","","","","","","","0","0.000","0","0","0","","0","0","0.00","0.00","0.00","0.00","0","0","0","0","0","0","0","0","","","","","0","0000-00-00 00:00:00","0","0", www.enatural.ro/,460###482###483###484,Femei###Cura de Slabire###Silueta###Scadere in Greutate,,282,282de4ac4b760bbb6ea8a818511c2b50.png#282de4ac4b760bbb6ea8a818511c2b50.png#0,0#0#0,##,
7950,"0","294","0","0","0","0","9","Virilmax","29.7","0","0","0","3C002","product","Virilmax va ajuta in mod natural sa obtineti performante mai bune atat pe plan fizic cat si pe plan psihic. Este un complex de plante traditional recunoscute ca fiind tonice si enrgizante.","<p><span style='font-weight:bold'>Actiune:</span> Este un complex de plante traditional recunoscute ca fiind tonice si enrgizante. Valorifica doar partea utila a acestor plante: fructe, frunze sau radacini.<br /> <br /> Virilmax va ajuta in mod natural sa obtineti performante mai bune atat pe plan fizic cat si pe plan psihic.<br /> <br /> <span style='font-weight:bold'>Compozitie: </span>ovaz, ginseng, guarana, vita de vie rosie, urzica, piper brazilian.<br /> <br /> <span style='font-weight:bold'>Continut: </span>30 capsule<br /> <br /> <span style='font-weight:bold'>Mod de administrare: </span>se iau 1-2 capsule dimineata cu un pahar de apa.</p><p></p>","0","0","0","","bec7eb5785426431df9ae3b04ee13f8f.png","0000-00-00 00:00:00","2011-03-13 16:37:00","0","","","","","","","","0","0.000","0","0","0","","0","0","0.00","0.00","0.00","0.00","0","0","0","0","0","0","0","0","","","","","0","0000-00-00 00:00:00","0","0", www.enatural.ro/,495###523,Barbati###Imbunatatirea performantelor sexuale,,0,bec7eb5785426431df9ae3b04ee13f8f.png#bec7eb5785426431df9ae3b04ee13f8f.png#0,0#0#0,##,

There is another one only for categories...is it posible to import separately?

Thanks.

PS: Please delete details if no needed any further.

Last edit: 13 years 7 months ago by Marius081.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 7 months ago #12779

You need to edit your CSV via excel and remove the columns you don't need and change the name of the ones you will use:
product_name is the same
product_price => price_value
product_number => product_code
product_desc => product_description
published => product_published
product_full_image=> images
category_name => categories (you will have to change the values to only have the name of the category and not the whole category path)

Then try again. That should work a lot better.

You can import categories separately yes. Just have a CSV like this:
parent,categories
cat1,"subcat1,subcat2"
subcat1,"subsubcat1,subsubcat2"
...etc...

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

  • Posts: 14
  • Thank you received: 0
13 years 7 months ago #12815

Hey Nicolas,

What about manufacturers?

I need to import them also (about 100).

Marius

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 7 months ago #12817

There are no manufacturers in hikashop. What users do usually is that they have a set of categories for them (that way, they can create a list of manufacturers on the front end, using the standard menus and modules of hikashop)

So you would have to add a main manufacturer category with one subcategory per manufacturer.
Then, you can just add each manufacturer to the products (you can have several categories for one product).

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

Time to create page: 0.046 seconds
Powered by Kunena Forum