Import not functioning although no errors.

  • Posts: 6
  • Thank you received: 0
9 years 10 months ago #185144

-- url of the page with the problem -- : hydromarket.co.uk/joomla
-- HikaShop version -- : 2.3.4
-- Joomla version -- : 3.0
-- Browser(s) name and version -- : 5.4.14
-- Error-message(debug-mod must be tuned on) -- : products stated uploaded but I dont see any products after using a HikaShop template CSV to upload.

It states the products uploaded successfully yet I can not see any products?

products stated uploaded but I dont see any products after using a HikaShop template CSV to upload.

It states the products uploaded successfully yet I can not see any products?

Any help would be highly appreciated, I've not got any errors on Joomla and have used CSV with ekmpowershop before switching to my own CMS through Joomla, any ideas guys?

I understand my category is showing sub cats with > but I named the first cat without a sub cat and that in fact did upload, yet the products are still not anywhere to be seen?

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

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

Hi,

It's probably a problem with your CSV file.
Please attach your CSV file so that we can see what you did and we'll be able to answer you.

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

  • Posts: 6
  • Thank you received: 0
9 years 10 months ago #185259

It was no problem with the CSV file when I selected UTF-8, the tutorials I watched did not select any and left it undisclosed, any reason why?

I am however getting table errors in certain lines with it, can descriptions be too long?

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

  • Posts: 6
  • Thank you received: 0
9 years 10 months ago #185260

Here is the file

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

  • Posts: 6
  • Thank you received: 0
9 years 10 months ago #185262

Sorry I didn't realize you had to click insert after you attached :ohmy:

Last edit: 9 years 10 months ago by hydromarket. Reason: attachment

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

  • Posts: 6
  • Thank you received: 0
9 years 10 months ago #185263

Hope this works, i've clicked add file and see the attachment:1 in []

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

  • Posts: 6
  • Thank you received: 0
9 years 10 months ago #185264

Sorry I had the file open!

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

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

Hi,

Sorry for the delay.

So I see quite a lot of problems in both the CSVs you provided.
First, for the hikashop 2.12.csv: take.ms/rWiXr
1. There are some problems with the quotes in the product description of some products leading to a mismatch between the columns and the data that should be in them around the 50th row of your file
2. Besides the product_name, price_value and product_description columns everything else is empty (besides the categories column for the first product). If you don't have anything in a column, don't put the column.

Second, for the Hydromarket 2015 CSV products.csv: take.ms/OHKdY and take.ms/f7LMT
1. There is the same problem with the quotes and the description at around line 50 of the CSV.
2. The product_parent_id has a D instead of a d at the end of the column name.
3. The product_parent_id column should contain the product_code of a main product or nothing. If it contains a product_code of a main product, it means that the current row is a variant of the main product and there should be a characteristic column with the value for each variant and for the main product (you can read more about importing variants/characteristics in our import documentation page: www.hikashop.com/support/support/documen...hikashop-import.html ). But maybe each line is its own product and in that case, you just don't need that column and should not have it.
4. You can remove the product_id column. The id will be added automatically by HikaShop.
5. The product_vendor_id should contain the id of the vendor, not its name.
6. The categories column should contain the name of the category of the product, not a price.
7. The parent_category column should contain only the name of the parent category or just remove it. If you already have your categories on your HikaShop, you don't need it and the name of the category is enough for each product.

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

Time to create page: 0.063 seconds
Powered by Kunena Forum