Did anyone solve this issue. I am trying to achieve the same thing. ie download lx w x h that have been input into the canada post mod fields
Printable View
Hi All!
I'm trying to master ep in Excel for easy uploading and downloading of all our products. It's working great for uploading, love it. I don't quite have downloading completely understood.
Whenever I download the list and open it in Excel the first zero in any ISBN goes missing. I know this is an Excel thing, but I'm wondering if there's anyway I can set the download not to do this, instead of just placing another character in front of each number.
If anyone has ideas please pass them on. Thanks.
I'm no Excel pro, but once you have the data in the spreadsheet (or a blank sheet with all the necessary fields) set the field to text as opposed to numeric. Once set clear everything but the header row & use this as template for importing your data.
Dennis
i am trying to use EP, bt i am trying to figure out how to do the proper dump.........seems like when i do my dump, everything is CSV, and I am wondering if it is possible to have each value in their own column...........i have tried every possible dump and just cant seem to figure it out.......I am looking to add about 10,000 products to my store, and to enter each in a CSV format is just too long of a process.....
Can anyone assist me with this process...
Any advice would be greatly appreciated
Kopy
When you download the dump it should be a text file. If you import it into Excel & define tab as the separator (I define all fields as text so leading 0's and dates aren't messed with by Excel) everything should be in it's own column. What are you trying to open it with?
Personally I prefer Microsoft Access. I can massage my data better.
Dennis
Is it possible to enter in a sort number field?
I've checked and checked, but somehow on my latest import, I've got some inconsistent results with regards to subcategorization:
In two main categories, there are only subcategory folders, NO products at the top level, as the zen cart designers intended (or so I am led to believe).
In 4 other main categories, the subcategories are visible on the catalog admin page, BUT all the subcategorized products HAVE ALSO been linked to their parent categories (so that clicking into the parent category will display all products from all subcategories). I actually like the second behaviour, but
a) I've read that I'll be in danger of a flaky store if I try to have parent categories contain BOTH products and subcategories;
b) I can't get the stubborn main categories to behave the same way, even using the multiple categories link manager.
Anyone have any advice on how to get all parent categories to behave the same way, without manually re-linking each product one at a time????
I'm trying to add a field for sort order, yet I'm not having much luck. Could someone point me in the right direction please?
Here's a quick question. It appears that Froogle is having issues with item descriptions that have quotations in them.
I notice that in the easypopulate.php file, there is a way to enable smart tags. Is there a way to have it strip out all quotation marks in the description text only?
For example, the following product description will not be allowed in Froogle:
"This products was voted "Best Item" of the year."
I would want the EasyPopulate script to simply strip out (or use a certain escape sequence when putting quotations in the description.
Can anyone help me on this one?
Hello everyone,
Maybe someone can help me with this. I know that EP can be modified to add more fields into it. I want to add the "products_priced_by_attribute" field to the feed as there are some things that require this. There were some commented fields but none are this one. I thought it'd be a good idea to ask how to add it instead of messing up my EP.
Thanks and Happy Holidays to All
Pete