8920 replies to this topic

[edukes]

Hello,

Using EP 2.77a. Not sure what's wrong but when I upload a file, it shows its being added but it does not show up in the catalog. No errors reported. I'm using excel to create the tab delimited file as I have always done, using EP to split it

I updated my catalog last month with no problems. As far as I know, I haven't changed anything.

Any help or suggestions would be greatly appreciated.

[GoTTi]

hi i am having a issue....

i installed a fresh copy of the oscommerce 2.3 and EP. when i go to import the products, it seems to be doing them fine. but it is not adding the items to the item list, either on the front or admin area of the cart.

the items show up however on the main page of the store, but they arent listed at all in a category on the left panel, or inside admin under products.

how do i get them to show up? what did i do wrong? thanks.

[geoffreywalton]

Try manually setting up 1 product so it appears in the sho and admin and then download a file using ep.

Then compare the file you are uploading to this reference file and see what you have missed out or mispelt in the headings.

HTH

G

[fap]

I have installed easy populate and have it working on my local server version 2.8
When I try to export the information even though I have added categories the file just has the basic information in it, none of the new categories that I have added manually
Any ideas?

Scrap the above- You have to create a product in each category before it shows in the file

Edited by fap, 08 April 2012 - 02:50 PM.

[GoTTi]

fap, on 08 April 2012 - 02:40 PM, said:

I have installed easy populate and have it working on my local server version 2.8
When I try to export the information even though I have added categories the file just has the basic information in it, none of the new categories that I have added manually
Any ideas?

Scrap the above- You have to create a product in each category before it shows in the file

ya i was also trying to add multiple cat's using EP and saw same thing on the excel file when i opened it up with empty categories. i think you can still mass add them. i didnt try it.

[ggrant3]

EP seems to be working fine for me, although I have been placing test orders and when I go to Admin area>Customers>Orders I get the following error above the list of orders

[color="#000000"][b]1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'This lists my Product's Title' and p.products_model = '[/b][/color][color="#000000"][b]This lists my Product's Model #[/b][/color][color="#000000"][b]' at line 1

select p.products_id from products p left join products_description pd on p.products_id = pd.products_id where pd.products_name = '[/b][/color][color="#000000"][b]This lists my Product's Title[/b][/color][color="#000000"][b]' and p.products_model = '[/b][/color][color="#000000"][b]This lists my Product's Model #[/b][/color][color="#000000"][b]'

[color="#ff0000"][TEP STOP][/color][/b][/color]

Any ideas why this is happening?

Edit:
When I uploaded my products via EP I took the stock osc shop (with the add-ons I installed) and downloaded a EP file.  Then I erased everything but the header row and then copied over my specific column information.

Edited by ggrant3, 09 April 2012 - 12:50 PM.

[geoffreywalton]

GoTTi, on 08 April 2012 - 03:04 PM, said:

ya i was also trying to add multiple cat's using EP and saw same thing on the excel file when i opened it up with empty categories. i think you can still mass add them. i didnt try it.

You need to add a product which is in the category for the category to be created.

HTH

G

Edited by geoffreywalton, 10 April 2012 - 03:15 PM.

[geoffreywalton]

ggrant3, on 09 April 2012 - 12:48 PM, said:

EP seems to be working fine for me, although I have been placing test orders and when I go to Admin area>Customers>Orders I get the following error above the list of orders

[color="#000000"][b]1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'This lists my Product's Title' and p.products_model = '[/b][/color][color="#000000"][b]This lists my Product's Model #[/b][/color][color="#000000"][b]' at line 1

select p.products_id from products p left join products_description pd on p.products_id = pd.products_id where pd.products_name = '[/b][/color][color="#000000"][b]This lists my Product's Title[/b][/color][color="#000000"][b]' and p.products_model = '[/b][/color][color="#000000"][b]This lists my Product's Model #[/b][/color][color="#000000"][b]'

[color="#ff0000"][TEP STOP][/color][/b][/color]

Any ideas why this is happening?

Edit:
When I uploaded my products via EP I took the stock osc shop (with the add-ons I installed) and downloaded a EP file.  Then I erased everything but the header row and then copied over my specific column information.

Is that the actual erro that appears on the screen or have you changed it in any way.

If you have not changed it then try removing the apostophe/single quote from the product name and description and then place another test order.

Cheers

G

PS Don't forget to delete the order that is ausing the problem.

[sjs3674]

A question about EP if I may.

I'm currently manually loading a store with potentially hundreds of products, with what feels like endless attributes. I've read that EP doesn't handle attributes well, and as such has put me off using/trying it out, is this still the case? as I'm looking for an easier way to load approx 500 more products with attributes. Is EP the way to go or should I stick to plugging away manually (ie one product at a time and all its associated attributes).

Many thanks.

edit: I should say i'm using 2.3.1 and have a few addons installed also.

Edited by sjs3674, 11 April 2012 - 04:31 PM.

[ggrant3]

geoffreywalton, on 10 April 2012 - 03:19 PM, said:

Is that the actual erro that appears on the screen or have you changed it in any way.

If you have not changed it then try removing the apostophe/single quote from the product name and description and then place another test order.

Cheers

G

PS Don't forget to delete the order that is ausing the problem.

The only changes I made to the error listed is I wrote "This lists my Product's Title" and "This lists my Product's Model #" so people would know what was in the quotes.

You said "Don't forget to delete the order that is ausing the problem." they are all casuing that error to display.  It will show the error for the most recent order and if I click on any other order it will show the related product title and model # for that other order.

[geoffreywalton]

sjs3674, on 11 April 2012 - 04:29 PM, said:

A question about EP if I may.

I'm currently manually loading a store with potentially hundreds of products, with what feels like endless attributes. I've read that EP doesn't handle attributes well, and as such has put me off using/trying it out, is this still the case? as I'm looking for an easier way to load approx 500 more products with attributes. Is EP the way to go or should I stick to plugging away manually (ie one product at a time and all its associated attributes).

Many thanks.

edit: I should say i'm using 2.3.1 and have a few addons installed also.

EP handles attributes fine you just need to set up the headings correctly.

I have just set up a store store where the products have upto 20 odd options with some options having between 2 and 10 values to select from.

Try downloading an EP export file and use that as a template.

HTH

G

Edited by geoffreywalton, 12 April 2012 - 07:21 AM.

[geoffreywalton]

ggrant3, on 12 April 2012 - 12:13 AM, said:

The only changes I made to the error listed is I wrote "This lists my Product's Title" and "This lists my Product's Model #" so people would know what was in the quotes.

If you change the error message how do you expect anyone to debug your problem?

G

[ggrant3]

geoffreywalton, on 12 April 2012 - 07:23 AM, said:

If you change the error message how do you expect anyone to debug your problem?

G

Again, the only thing I changed was the actual product title and model #.  The message is the same besides those values.  It affects every single item so it isn't like it is one specific product title or model #

Edited by ggrant3, 12 April 2012 - 12:48 PM.

[geoffreywalton]

OK, your call.

Good luck.

Cheers

G

[russalpcs]

Hi all

I have had my own website for a couple of years now - I have recently changed to OSC 2.3.1 and EP v2.76i and have also recently had to change all my model name to my suppliers' codes for easier updating - in this process I have changed my model name length for 12 to 20, but in the last 2 updates, I see it keeps adding duplicate products  - supplier code is "CA-SATALT90-1B" - I have just downloaded a complete stock file from my website and all codes longer than 12 have been shortened to 12, maning that everytime I update, it adds "new product" when the product is already there! I now have 4 or 5 of the same items on my site!

How do I fix this error?

Thx
Russel

[russalpcs]

Hi all

I have had my own website for a couple of years now - I have recently changed to OSC 2.3.1 and EP v2.76i and have also recently had to change all my model name to my suppliers' codes for easier updating - in this process I have changed my model name length for 12 to 20, but in the last 2 updates, I see it keeps adding duplicate products  - supplier code is "CA-SATALT90-1B" - I have just downloaded a complete stock file from my website and all codes longer than 12 have been shortened to 12, maning that everytime I update, it adds "new product" when the product is already there! I now have 4 or 5 of the same items on my site!

How do I fix this error?

Thx
Russel

[russalpcs]

Hi again

Strangely enough - it is updating the pricing correctly on each item?

Russel

[MouseSA]

hi there, i have no idea what  i did but followed instuctions to the best of my ability.
Now problem is that after installing easypopulate when i click on catalog--> product attributes in the backend of OSC then i come out to the EP documentation.
What file did i stuff up to do this?

[zeus_r6]

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/xxxxx/public_html/test_store/admin/easypopulate.php on line 1082

Anybody know what this error points to in a 2.3.1 shop?

[puddlec]

zeus_r6, on 30 April 2012 - 12:24 AM, said:

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/xxxxx/public_html/test_store/admin/easypopulate.php on line 1082

Anybody know what this error points to in a 2.3.1 shop?

Which version of easy populate are you using?