Magento

changing “admin” to “default” worked like magic. Thanks for the tip (you beauty!).
The csv exported is a bit misleading.
is there an easy way to determine what your category ids are? best I could come up with is

How frustrating is this problem?!!! I find that I need to open each product in the admin backend and press ‘Save And Continue Edit’. Sometimes pressing ‘Save’ makes the ‘Please Wait’ dialogue hang the whole browsing window. Perhaps time to read up on Magento Database Optimisation?

jonahcoyote - 17 April 2008 08:47 PM

Hey everybody, I may have figured it out. Give this a try. After reading this post: http://www.magentocommerce.com/boards/viewthread/6220/ - I saw right away that that this person used the value “default” in the store field instead of “admin” like I was doing before.

I switched this value to “default” for some existing products and also for a new product and it inserted the products properly and they display without me having to edit them or run the above sql.

I hope this helps!

Cheers,
Jonah

This worked perfectly for me. In Excel with my .xml file open, I simply changed ‘admin’ to ‘default’ and imported the lot via the standard import all products profile.

Thanks!

B

Ok....I have been at this from the beginning and felt everyone’s pain!

I have imported 550 products with the store set to default, and I can see them on the front end, but the problem is the system has not created them with an entity ID and their attributes do not get indexed for the layered navigation to work.  So............I am back to clicking and opening and saving 550 products and my finger is getting a bit sore........

Any ideas or links would be appreciated. 

(V 1.098)

hey roco,

to get products appearing in the layered navigation goto cache management and click “refresh layered indexes” this will make the products visible for the layering… Cant say i can help with products not showing up in general

hth
brendan

Thanks for the reply, but there is no option in my cache management that is called “layered indexes”.......  where is this option you speak of?

sorry, i was going off my bad memory

ok

look under system\cache management

there is a section in Catalog called
”Layered Navigation Indices”

hit the refresh button

this will reindex the layered navigation based on all products

Click thumbnail to see full-size image

This looks like version 1.1 and I have not yet upgraded.  :( Was this a bug that they implemented this functionality for?

Im not sure,

i had a look round and couldnt see much documentation about....

Sort of makes sense though.
Having the layered Navigation in a table that can refreshed manually

I think they did it this way so that when you did an import of data, the import did not automatically just refresh the layered nav for your products. Especially if you import your products as disabled first (i do anyway), then check them, before updating to Enabled.

I think it allows you to better stage your updates to your catalog without impacting the front end navigation.

cheers
Brendan

WaelHReda - 30 April 2008 06:16 AM

I heard if you change it to default then the products show up on the frontend and not in admin. Is that right?

This happened to me.  I changed “admin” to “default” in my xml file and it processed perfectly.  When i go to the frontend the description from my xml file reflects the new changes, but the backend shows the old description.

Now if i go to the admin and edit the description, it DOES NOT reflect on the frontend....

I have cache disabled and refreshed a few times so i assume it is in the table somehow...any explanation how this is possible?

I kind of have similar problem, i think.  When I import I can see the products just fine, but i dont get a price in the layered navigation.  If i go into the item on the admin side and then click “save” and then refresh the storefront, it now shows in the layered navigation section. 

Is this related to what you all have been seeing, and has anyone fixed this before?

Thanks.

I am completely stumped on how data flow relates to the backend admin interface.  It seems that when i import products (using an exported template), the backend admin interface is completely useless and does not reflect any further changes on the frontend.

Here is my problem:

1) exported ALL PRODUCTS as CSV
2) updated and added products using existing fields from above export
3) imported products successfully but now only 11 products are showing up.  Before the export i had 37 products showing up.

Now looking at the CSV, i can’t find ANY difference in the products that are showing up against the ones that are not! Furthermore, when i go to the backend interface and try to enable the product again it will not show up on the frontend.

Here is what I know aftersuccessfuly importing:

• all products show up in the backend
• all products were changed to ‘out of stock’ —ALTHOUGH 11 products still show up on the frontend!
• all category selections are unchecked
• there is no difference (in each filed) between the 11 showing up and the 26 not showing up

• using magento 1.1.6 and php v 5.0.51
• cleared cache in browser
• disabled cache in magento
• refreshed ‘Layered Navigation Indices’

I don’t know enough about phpmyadmin to clear the issue and now i can’t get these products back.  My biggest question is why the data flow import DISABLES the backend interface functionality???

Here is a specific example:
product named ”Bounce” shows up fine on the front end but shows this on the backend interface:

visibility: nowhere
quantity: 0
out of stock
no categories selected
no image showing

thank you for any help on this!

I would love to get answer for this if anyone can explain...I am at a stand still .....don’t want to add any new product until this gets resolved.

thanks!