I have an immediate task I need to complete NOW, before anything else (sql task):
for our magento site - [login to view URL]~pearlsco/[login to view URL]
for each product, I want to copy the product - name & description & short description from store id 2 (which is our hebrew language store) to the default store (id 0). we dont need to duplicate the products. only copy this attributes to the store id 2 products.
all we need is the sql query