Some products not showing up in store

[RiverCity]

Hello,
If this has been covered could someone send me the link, I caught myself looking but at my age I could have gone right past it.

Using Apsona, I just uploaded one suppliers products to my store, the datafile I copied into Apsona to upload had 3611 items. I didn't receive any errors and everything looked like it went ok. Using Apsona again, I just exported a csv file from my store to check on a couple other things I was working on and got to looking at it and noticed there were only 3429 products from that supplier in the csv file. I'm missing the other 183 that looked like they were uplaoded.

Like I said, I didn't receive any errors while uploading, where would I start looking to try to find out why those 183 didn't upload or at least not showing up?

Thanks for any help,

Jim

[Ajeh]

Go to phpMyAdmin ...

Browse the table:
products

and ensure that all Product Records contain a:
master_categories_id

that is greater than 0 ...


Check that all Products have a Product Description ... go to phpMyAdmin and run the SQL of:

select p.products_id, p.products_date_added, p.products_last_modified
from products p
left outer join products_description pd on p.products_id = pd.products_id
where pd.products_id is null;

Does anything show up?


Try checking to see if any products_id is missing from the products_to_categories table ...

Go to phpMyAdmin and in the SQL run:

select p.products_id, ptoc.categories_id 
from products p
left outer join products_to_categories ptoc on p.products_id = ptoc.products_id
where ptoc.products_id is null;

Does anything show up?

[RiverCity]

Hi Linda,

Not being to familiar with running sql stuff, I checked with Hostgator and they told me how to do it but also ran the ones that you suggested and here is the reply they suggested I reply back to you with.

Thanks for your help,
Jim

Their reply:

--------------------------------------------------------------------------------
mysql> select p.zc_products_id, p.zc_products_date_added, p.zc_products_last_modified from zc_products p left outer join zc_products_description pd on p.zc_products_id = pd.zc_products_id where pd.zc_products_id is null;

ERROR 1054 (42S22): Unknown column 'p.zc_products_id' in 'field list'
--------------------------------------------------------------------------------
mysql> select p.zc_products_id, ptoc.zc_categories_id from zc_products p left outer join zc_products_to_categories ptoc on p.zc_products_id = ptoc.zc_products_id where ptoc.zc_products_id is null;

ERROR 1054 (42S22): Unknown column 'p.zc_products_id' in 'field list'
--------------------------------------------------------------------------------

[Ajeh]

You added too many zc_ ...

Try using:

select p.products_id, p.products_date_added, p.products_last_modified
from zc_products p
left outer join zc_products_description pd on p.products_id = pd.products_id
where pd.products_id is null;

select p.products_id, ptoc.categories_id 
from zc_products p
left outer join zc_products_to_categories ptoc on p.products_id = ptoc.products_id
where ptoc.products_id is null;

[RiverCity]

I sent Hostgator your previous instructions as it's all still greek to me, their reply is below. Do you think it would correct the situation if I just uploaded a new csv file with these missing items on it and upload them as new and not updated?

Thanks for the help,
Jim


Their reply......

Thank you for your reply. It looks like the query they provided is different from the one before:

select p.zc_products_id, p.zc_products_date_added.....

versus:

select p.products_id, p.products_date_added....

It seems that the tables don't necessarily have zc_ in front of them.

When I ran one of the queries they provided it returns results:
[root@gator2008 /home2/jstiles/public_html]# mysql jstiles_zncr1 -e "select p.products_id, ptoc.categories_id
>
> from zc_products p
>
> left outer join zc_products_to_categories ptoc on p.products_id =
> ptoc.products_id
>
> where ptoc.products_id is null;"
Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead.
+-------------+---------------+
| products_id | categories_id |
+-------------+---------------+
| 206 | NULL |
| 207 | NULL |
| 208 | NULL |
| 209 | NULL |

....and so on.

[Ajeh]

I am thinking that you have possibly invalid categories_id in the products_to_categories table as none should be blank, NULL or set to 0 ...

You might try backing up your database and redoing the update from your cvs but I do not use tings to import Products so I really cannot tell you the "best" solution ...

Perhaps contacting Apsona about your issues might be a solution, or posting on the support thread for it ...