I just saw the second part of your post. It has nothing to do with that table. It's only the "products" table.
I'll be around for another hour or so. Let me know how you make out.
Printable View
I just saw the second part of your post. It has nothing to do with that table. It's only the "products" table.
I'll be around for another hour or so. Let me know how you make out.
Thanks Jeff. Turned out default was set to 0. have now edited this bit to default to 1. Hopefully this will make a differnce.
Thanks so much for your help :thumbsup: :cheers:
Always glad to help when I can.
I'm trying to use the EP to adjust stock by attribute. I did a test on a few products and I screwed up something. Now all of my variants display this symble " : " instead of the name (i.e. instead of showing small, medium, large - each one showed : . The quantity was correct though)
Is there a quick and dirty guide to the stock by attribute template for EP? I did a thorough search of not only this forum, but google as well.
Hi again
Need a little more help. I have 3 new columns in the products table that I need extracted into the Full EP file when I run EP.
These are:
products_height
products_length
products_width
Can anyone tell me what code I would need to add and to what file I would need to add it too. My guess I would need to add it to file easypopulate.php?
TIA
i've configured my zencart site to use iso-8859-2 encoding. my database zc1 is set to collate to utf-8.
when i add products via Admin -> Catalog -> ... new product, i use my language characters (čćžšđ) and they display ok on site.
i downloaded EasyPopulate's complete tab-delimited .txt file, edited it in notepad++ and saved using utf-8 encoding. then i go to EP, Upload EP File, select the file and hit insert into db. Everything ends ok, but when go to se the products on my site, the text is this "mi� cc��d" instead of this "miš čćžšđ".
What am I doing wrong?
When i click on:
Download Complete tab-delimited .txt file the file does not show v_categories_name_1 etc.. can someone help please
If its a new install, try adding a category and a product before downloading that file.
If your store has products and they are priced by attributes, then good luck getting the download to look right. One I tried that way was really unusable.
If its a new install and it still looks funky after adding that catagory and product, I would reread the install instructions and try again.
Thank you.. i reinstalled and followed all the instructions and it worked great.
how can i make updates to my product list with EP?
basicly, i want to add my products first and later their description.
first, i want to insert a product list with product_id/model, name, price and category. then i want to insert a new file with almost same product_id/model but only description and weight. when i say almost same, i mean that first file has 40 models and second only 30 of those 40.
when i do it like this for 4 products, my category sidebox says 8 and shows only 4 (from the first file). also, the descriptions (second file) are not shown anywhere. also, EP says NEW PRODUCT when i upload my update.
what am i doing wrong? how can i do this?
this is my first file (+ is for empty tab):
1100 + prod_1 + + + + + 100 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
2200 + prod_2 + + + + + 200 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
4400 + prod_4 + + + + + 400 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
5500 + prod_5 + + + + + 500 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
this is my second file:
1100 + + desc_prod_1 + + + + 100 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
2200 + + desc_prod_2 + + + + 200 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
3300 + + desc_prod_3 + + + + 300 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
5500 + + desc_prod_5 + + + + 500 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR