Continue to Products not displaying in categories.

  • Posts: 79
  • Thank you received: 0
13 years 3 months ago #5495

I tried the reinstall but I still have no luck.

I may have misspoke earlier today also.
In =Hika_products i have 1061 same as my csv
In =Hika_category_products I have 869. So the missing products are not getting into the category_products in the db's table.
Any new thoughts?
Thanks,and sorry for all the troubles.

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

  • Posts: 81631
  • Thank you received: 13085
  • MODERATOR
13 years 3 months ago #5499

Which version of hikashop are you using ?

For the products missing, does the categories exist ?

From what you're saying, I understand that the 869 products are in there and that you can access them right ? So, the best would be to find one product which doesn't and try to understand why it wasn't linked to a category. Maybe you could copy its CSV line here so that we could better see the problem.

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

  • Posts: 79
  • Thank you received: 0
13 years 3 months ago #5501

the free version(essential?)
The categories exist, one of them has products that are displaying, but were maunally added. The upc column(D) with a letter eg 205a are shown front and back. The numerical are not added to the db _category_Products. There are multiple other products in different categories thatare not being shown,but these few are whats so puzzling to me. Half in,Half out????

French Angel 199.99 17 205026 1 lb
Grey Angel 85.79 17 205034 1 lb
Asfur Angels 179.99 17 205036 1 lb
Rock Beauty 49.99 17 205040 1 lb
Koran Angel 179 17 205042 1 lb
Maculosus 149.99 17 205057 1 lb
Nox 33.59 17 205535 1 lb
Yellowfin Nox 72.99 17 205a 1 lb
Blue 68 17 205b 1 lb
Blue Fin Damsel 8.99 17 205c 1 lb

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

  • Posts: 81631
  • Thank you received: 13085
  • MODERATOR
13 years 3 months ago #5503

Aren't you missing the commas/semicolons in there ?

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

  • Posts: 79
  • Thank you received: 0
13 years 3 months ago #5505

I copied out of a spreadsheet Tab delimeted. When it's saved itgets saved as csv with ;," as the text field delimeters. Thats how all of the other products were uploaded also.

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

  • Posts: 81631
  • Thank you received: 13085
  • MODERATOR
13 years 3 months ago #5508

Could you open the CSV with a text editor like notepad++ and copy those same lines here ? It's just to check that the format is good.

Also, if you could copy along the header of the file (the first line).

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

  • Posts: 79
  • Thank you received: 0
13 years 3 months ago #5511

ive got $ formating in all numeric cells , lol? who knew. I'll take itout and see whst it does.

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

  • Posts: 79
  • Thank you received: 0
13 years 3 months ago #5518

still no luck. unless i am completely formatting the csv and its delimeters wrong,im still stumped.

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

  • Posts: 81631
  • Thank you received: 13085
  • MODERATOR
13 years 3 months ago #5519

Could you copy some lines of the CSV here (the lines in your text editor, not in excel) ?
Also, if you could copy along the header of the file (the first line).

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

  • Posts: 79
  • Thank you received: 0
13 years 3 months ago #5521

"product_name";"price_value";"categories";"product_code";"product_weight";"product_weight_unit "
"Bicolor";17.99;21;215001;1;"lb"
"Red Lip";19.99;21;215004;1;"lb"
"Horned";26.49;21;215005;1;"lb"
"Midas";37.89;21;215006;1;"lb"
"Smith's";26;21;215010;1;"lb"
"Barnacle";52;21;215011;1;"lb"


these are showing front and back.
"Blue Ribbon";99.99;25;235012;1;"lb"
"BandedSnake";37.99;25;235020;1;"lb"
"Garden";25.99;25;235024;1;"lb"
"Golden Dwarf";249.99;25;235045;1;"lb"
"Flaming Prawn Goby";51.99;26;230001;1;"lb"
"Bi Color";4.99;17;205001;1;"lb"
"Bi Color";34;17;205002;1;"lb"
The last set are some of the ones that aren't showing. Every line was initially added via the same csv? I dont know why it would dropcertain categories.I've triple checked the categorie links....

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

  • Posts: 79
  • Thank you received: 0
13 years 3 months ago #5524

Fixed,I dropped both tables again, and a reinstall. I tend to over complicate things,????
Thanks for the help!

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

  • Posts: 81631
  • Thank you received: 13085
  • MODERATOR
13 years 3 months ago #5529

I see that the categories of both sets of products are not the same. Maybe the category id wasn't the correct one, or the type of the category wasn't the correct one (the category type needs to be "product" in the database. If that's not the case, as it could happen in some strange cases, then the categories might not show up as well as the products attached to them).

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

Time to create page: 0.075 seconds
Powered by Kunena Forum