Help with Importing Products

[flyn]

Hello. I was able to import products to our system thru a CSV file. The problem I have is that none of the items appear in our system as i view the site.

I noticed none of them are check off where default store should be checked. How I can import that products so they are automatically enabled and tied into the default store.

I know I can go one bye one and check them off but there is over 200 items.

Thanks

[llegrand]

Hey Flyn,  check your column in this db table and field  to see if there is a zero -
Table  -  product_to_stores
field  - StoreID

Default store is 0

Screen shot of one of mine -  my table has prefix of ab,  that could be different on your table .

Lee

[flyn]

Thanks 

If I have that then do I need to do anything in the exported CSV I generated?

[llegrand]

I am not following your question - try asking it with more details

[flyn]

If I see that in the database then is there a column in the CSV I exported where I need to also add the 0 so once it imports it knows default store?

[flyn]

I found this column - products_to_stores[0].store_id

It is blank. Should I add zeros in there?

[llegrand]

yes,  the default store is '0' zero

If you add multistores-  then there will be an additional line item for each product that shows that store's unique ID (some other number)

[flyn]

YES!! Not it worked! 

Thanks Le