How to prepare an Excel file for import

  • Posts: 13201
  • Thank you received: 2322
10 years 4 months ago #161741

Hi,

If the category is a child of a child, it's not a problem until the category name is unique the product will be added in the correct category.

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

  • Posts: 27
  • Thank you received: 0
10 years 4 months ago #161879

I'm sorry but I simply can't understand your answer.
In the modified spreadsheet you returned to me, all the categories are simply placed on after the other in a single column, so i cant see how HikaShop would differentiate them as anything other than unique Main Categories.

Let me try an easier to understand example, say I was setting up a Fashion shop selling clothes and footwear.
Under a main category of;
FOOTWEAR, I want two sub-categories of MENS and WOMENS
under the MENS Subcategory, i want two additional Subcategories of DRESS and SPORTS
So how would these categories be entered in the single column ?
Would it be something like;
FOOTWEAR
FOOTWEAR_MENS
(FOOTWEAR_WOMENS)
FOOTWEAR_MENS_DRESS
FOOTWEAR_MENS_SPORTS

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 4 months ago #162027

No. You don't need to specify all the category structure when you add a product.
You just give the name of the category where you want the product to go and it will go in that category.
So with your example, if you just enter FOOTWEAR_MENS_SPORTS in the categories column, the system will add the product to the category FOOTWEAR_MENS_SPORTS which is already under the category FOOTWEAR_MENS which is under the category FOOTWEAR.

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

  • Posts: 27
  • Thank you received: 0
10 years 4 months ago #162199

Hi,
i will not be adding any products one at a time.
The source Price List (Polycom) has over 2,000 line items and i need to automate the creation of an initial HikaShop ready .csv with all Parent Categorises and 2 levels of , Sub-Categories for the first month, and every subsequent month..

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 4 months ago #162228

Hi,

I know you can't add the products one at a time. That's the goal of the import system to add a whole bunch of products together in one go. So it doesn't change what I said so far.

And you can't pre create the categories via the interface ? Will the categories change in the future ?
If yes, then I do understand that you want to have the CSV embed the hierarchy of the categories in it.
In that case, you can have empty lines at the begining of your CSV with just the categories hierarchy and then just mention the categories in the products.

For example:

parent_category,categories,product_name
FOOTWEAR,FOOTWEAR_MENS,
FOOTWEAR,FOOTWEAR_WOMENS,
FOOTWEAR_MENS,FOOTWEAR_MENS_DRESS,
FOOTWEAR_MENS,FOOTWEAR_MENS_SPORTS,
,FOOTWEAR_MENS_DRESS,product 1 in the dress category
,FOOTWEAR_WOMENS,product 2 in the womens category
as you can see the first few lines are only for constructing the category tree, and the two last lines are adding the products directly to the correct category without having to specify the category structure.

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

  • Posts: 27
  • Thank you received: 0
10 years 4 months ago #162262

Hi Nicholas,

Thank you very kindly for making this easier to understand.

I estimate the Price List I wish to import has around 300 Categories and Sub-Categories and 2,000 Products
Also,, this list will be updated every month.
So it is imperative that i can automate the process of creating and deleting Categories and Products.

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

  • Posts: 27
  • Thank you received: 0
10 years 3 months ago #166649

Hi,
i have recruited help from Charles who has much better skills with spreadsheets.
Some issues remain but firstly, would you mind looking at the current .csv which has quite complex parsing of categories from the source spreadsheet from Polycom into Charles converted spread sheet..

The source (unaltered) Polycom spreadsheet is also attached

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 3 months ago #166663

Hi,

I did get your source spreadsheet, but not the resulting CSV in your message. Could you provide it as well ?
Is there something specific you want me to comment on in the CSV ? Just check if the format is ok ?

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

  • Posts: 27
  • Thank you received: 0
10 years 3 months ago #166706

Hi,
Yes, could you please check to see if it should install OK on HikaShop?

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 3 months ago #166714

Hi,

It is almost valid. The one thing I saw is that in the "images" column of the CSV, it's the file name of the imge that you need to specify, with the extension. So DC5.jpg for example, not just DC5.

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

  • Posts: 27
  • Thank you received: 0
10 years 3 months ago #166763

Thanks for that.
I will add in the images in the correct format and try an upload next

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

  • Posts: 27
  • Thank you received: 0
10 years 3 months ago #167197

Hi,
i want to keep this thread intact but will ask Charles to comment, send files and ask questions

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

  • Posts: 36
  • Thank you received: 5
10 years 3 months ago #167204

Hi,

I managed to find the .jpg for Tims project.
My concern is linking the .jpg with the "Product".
When researching I did not find a link that shows the manufacture code IE:"7200-26920-002" to a Image.
Which I think in this case may be "hdx-8000-01.jpg".
Is there a file that already has the Product and Image?
If not if I populate the .jpg to the csv file will it link to the Image?

Charles

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 3 months ago #167284

Hi,

Normally, you put the name of the images in the CSV, and you upload all the product images in the folder media/com_hikashop/upload.
Then, HikaShop links automatically the imported products with the image files in that folder based on your CSV.

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

Time to create page: 0.091 seconds
Powered by Kunena Forum