Easy Populate 1.2.5.4 support

michellewardley By default the answer is no, anything is possible with a bit of coding (probably a lot...) images work from the images folder of ZC not from outside links other than placing an <img> tag in html in your description of the product.

totomony Please use version 1.2.5.4 it just works...:clap:
if you want to use 1.2.5.5 then search for a thread on that version if there is not one please start a thread...

Hi thanks for the reply - I was actually looking for a store look and thats why it would be great to have such a function.

would there be a way for me to remove the add to cart button and buy now button and then install a sql query to add my affiliate link for each product?

it would be good if it can be done. I can get this done through wordpress however i dont like the overall feel -

thanks

schoolboy:

Then there is no point using zencart as it is not designed to have these functions as a re-direct.

Thanks for your prompt reply .I will uninstall the 1.2.5.5 and try the v.1.2.5.4. :P

Scrat:

michellewardley By default the answer is no, anything is possible with a bit of coding (probably a lot...) images work from the images folder of ZC not from outside links other than placing an <img> tag in html in your description of the product.

totomony Please use version 1.2.5.4 it just works...:clap:
if you want to use 1.2.5.5 then search for a thread on that version if there is not one please start a thread...

abs007:

Hi thanks for the reply - I was actually looking for a store look and thats why it would be great to have such a function.

would there be a way for me to remove the add to cart button and buy now button and then install a sql query to add my affiliate link for each product?

it would be good if it can be done. I can get this done through wordpress however i dont like the overall feel -

thanks

There is a crude hack you could use - but it's clunky.

Set the shop to "Showcase with prices"

When you add a new product, in the PRODUCT DESCRIPTION FIELD, insert a html link operated with an image button, to re-direct the visitor to your affiliate site:

eg:

To purchase this product, please click the button:<br />
<a href="http://www.your-affiliates-site.com/path/to/product"><img src="images/buy_product.jpg"></a>

hi schoolboy thanks 4 da reply. Plz pardon da spellings-im replying from my phone. Is there a way i could do this by some sort of sql coding? If i will b adding like 500 products then that wud take a long time, i guess it wud b hard as each product would need directing 2 a diff page- i may still give it a shot. Ive been thinking that if i cud do something 2 da data feed b4 uploading it then it may save me much time. Is there any advise u cud give? Also wud u knw if da google froogle mod will work with a showcase store?Thanx > schoolboy:

There is a crude hack you could use - but it's clunky.

Set the shop to "Showcase with prices"

When you add a new product, in the PRODUCT DESCRIPTION FIELD, insert a html link operated with an image button, to re-direct the visitor to your affiliate site:

eg:

To purchase this product, please click the button:<br />
<a href="http://www.your-affiliates-site.com/path/to/product"><a href="images/buy_product.jpg"></a>

*Posted via Mobile Device*

abs007 To do what you are asking to do is pretty straight forward but it would need coding but not in sql, sql is really only for inserting information into Mysql not manipulating text. The easiest way would be to use OO or Excel and 'concentrate' fields with your data to create the format you need and then import via EP, or look at the Python language which is very easy to learn which would do this very easily.

hi scrat thanx alot, just wat i was looking 4. I knew it cud b done in zencart its just trying 2 drill dwn 2 wat needs 2 b done n then looking 4 da solution, i find it amazing. So i need 2 make changes 2 da data feed. The data feed will b a .csv file i think and hope whichever method i end up choosing-excel-00 or python it wont matter.ive actually got am account wid totaltraining.com so will c if i can get a tutorial from there.many thanx 4 da reply > Scrat:

abs007 To do what you are asking to do is pretty straight forward but it would need coding but not in sql, sql is really only for inserting information into Mysql not manipulating text. The easiest way would be to use OO or Excel and 'concentrate' fields with your data to create the format you need and then import via EP, or look at the Python language which is very easy to learn which would do this very easily.
Posted via Mobile Device

abs007
There are lots of Free Python tut. on-line some Video some text just 'goooooogle' for them;

http://diveintopython.org/
http://showmedo.com/videotutorials/python
http://www.sthurlow.com/python/

rgds
A

Hi scrat
thanks alot for the reply - wow isnt python big - never done programming before and its gonna be a hard learn. Im just not sure where to start. Ive been reading tutorials and its started to give an introduction to small programming strings and is introducing variables - data - objects and all sorts. Its showed me how to use python to calculate mathematical equations which is great and has also introduced me to javascript and VBScript -

This is all great but i feel im going down a route which is not needed. Im not sure where what i am actually looking for to add the links to this .csv file. Is there any sort of buzz words that I should be using in my search to find the actual tutorials which i am looking for

sorry fto be a pain

I tried the command below, and got a single-word response: "Failed." The table and record names look correct; is the SQL syntax not right?

awev:

Hello TreeWoman,
I made a mistake in answer to the question you posted.

Using the Install SQL patch under tools in the admin section we are able to change the show quantity box status. The command is:

UPDATE products SET products_qty_box_status = '1'

The '1' turns it on, while '0' would turn it off. I found the info here

mzimmers:

I tried the command below, and got a single-word response: "Failed." The table and record names look correct; is the SQL syntax not right?

I got a similar response until I put back-quotes around the table and field names:

UPDATE products SET products_qty_box_status = '1'

abs007 |This is getting a little off topic for this thread but,
basically you will be manipulating text in the description field [ v_products_description_1 ]
Have a look at the python csv module which will do what you are after to write the file, but you need to learn some basic's of Python, basically "string" manipulating http://www.network-theory.co.uk/docs/pytut/Strings.html

Some Video tut.

Hi scrat , yes your right it is getting off topic - sorry and your help is much appreciated.

Regarding easy populate I have been reading through the posts but am still finding it hard to understand how to load a basic .csv file or tab delimited. I have read the read me file that comes with it.

I have been given a data feed from commission junction but when i try to uplaod it i get an error which read

No model field in record. This line was not imported

Im not sure if i need to create the categories before i upload the feed and maybe this is the reason why its not working. Or do i need to change the headings of the datafeed so that they match the Full-EP2010Mar27-0707.csv file which i some how managed to get after installing easy populate and imported the file from the temp file.

After viewing this file i noticed that it only had headings and not any data. Now im not sure if this is a file which would have had data if i had products in my store. As it stands i am experimenting on a brand new store with no products in it.

Thanks for all your help so far and i will be sure to take my python queries elsewhere.

I uploaded a test file to my store and now I need to remove the test data to upload my real file. How do I go about doing that? Do I just use the EP download feature or is there some other way?

outeredge2:

I uploaded a test file to my store and now I need to remove the test data to upload my real file. How do I go about doing that? Do I just use the EP download feature or is there some other way?

In the SAME test file (txt file) change v_status values to 9, then run that file through EP.

v_status = 9 means "delete the product".

schoolboy:

v_status = 9 means "delete the product".

That's a great little tidbit of information. Is there a place where this kind of knowledge about EP is collected and kept? Something a bit more brief than this forum?

I wrote a tutorial on EP:

http://www.zen-cart.com/wiki/index.php/Easy_Populate

Great wiki, schoolboy. Is there some way for a link to this to be inserted at the top of this thread? It might eliminate a lot of questions.

schoolboy:

I wrote a tutorial on EP:

http://www.zen-cart.com/wiki/index.php/Easy_Populate

mzimmers:

Great wiki, schoolboy. Is there some way for a link to this to be inserted at the top of this thread? It might eliminate a lot of questions.

I agree. This is really a good Tutorial on it. It is my fault with some of the items as I don't read it correctly or i miss read it but to all those other Newbies like me... read it fully and most of your EP answers are in there.

schoolboy:

I wrote a tutorial on EP:

http://www.zen-cart.com/wiki/index.php/Easy_Populate

thanks alot schoolboy

just what i was looking for -