Auction Lister Pro (ALP) Support

[maxrisc]

Which MySQL version are you using?

[scooper55]

hi could you tell me if this will also work with ebay.co.uk

thanks
shaun

[FatGuyinAZ]

I will give you all info from my ISP:

Database: MySQL 4.0.25-standard
PHP Version: 4.4.1 (Zend: 1.3.0)
Server OS: Linux zelter.lunarpages.com 2.4.21-50.ELsmp #1 SMP Mon Jun 11 18:13:29 EDT 2007 i686
HTTP Server: Apache Webserver

Thank you,
Steve

[dvasdekis]

I'm sorry if I'm missing something absolutely obvious, but in version 0.5.3 the install/documentation folder is empty. Am I just thick?

[modchipfitters.co.uk]

hi could you tell me if this will also work with ebay.co.uk

thanks
shaun

yes this does work with ebay.co.uk you just need to use 3 as the country code when installing

[maxrisc]

ALP 0.5.3 Installation Instructions

You need to have your eBay Sandbox Keys and Token. If you don't know what this is or don't have them then search on http://auctionlisterpro.com to find the article on how to get them. Please make sure you get a "regular" token not a "REST" token.

1. Download and unzip the latest image of ALP from http://auctionlisterpro.com or http://zen-cart.com
2. Unzip the image to your local hard drive.
3. FTP the files to a folder on your webserver “OUTSIDE” of your web store root, preferably http://www.mystore.com/alp
4. Run the installer located at http://www.mystore.com/alp/install
5. Follow the on screen prompts. If you are not sure what something is then click the question mark (?) for further information.
6. Make sure you specify your shopping cart's database when it asks you for database info.
7. When installation has completed make sure you remove the folder /alp/install


You will need to create an .htpasswd file to protect this installation. When you want to list your products on eBay simply go to http://www.mystore.com/alp

Notes:
=====
- 0.5.4 will have an administrator login so you won't need an .htpasswd file.
- The installer is also being rewritten for clarity and improvements.
- There is a bug with BIN not showing up as successful auction that I am working on to correct. The person is still allowed to purchase the item on eBay.
- There is no checkout redirect/email checkout with the Zen Cart version at this time.

[maxrisc]

That's very interesting. It should either return a completely blank page or a page with items in it from ended auction.

Can you run this command against your database and tell me what it returns?

This might have to do with the BIN now bug that I am working on.

SELECT * from auction_list;

I will give you all info from my ISP:

Database: MySQL 4.0.25-standard
PHP Version: 4.4.1 (Zend: 1.3.0)
Server OS: Linux zelter.lunarpages.com 2.4.21-50.ELsmp #1 SMP Mon Jun 11 18:13:29 EDT 2007 i686
HTTP Server: Apache Webserver

Thank you,
Steve

[troy77]

Reinstall ALP and specify your "Cart" database.

I have done all that unless im doing it wrond, ive entered all the details but still comes up with that error??

[maxrisc]

If you have done that then the DB Prefix is the issue. In /alp/includes/configure.php there should be a line like this but it may be missing.

// define our database connection
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'username');
  define('DB_SERVER_PASSWORD', 'password');
  define('DB_DATABASE', 'mydatabase');
  define('DB_PREFIX',''),  
  define('USE_PCONNECT', 'false');
  define('STORE_SESSIONS', '');

Put your database prefix in that line including the "_" if there is one.

// define our database connection
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'username');
  define('DB_SERVER_PASSWORD', 'password');
  define('DB_DATABASE', 'mydatabase');
  define('DB_PREFIX','fishkrib_'),  
  define('USE_PCONNECT', 'false');
  define('STORE_SESSIONS', '');

Save the file and give it a try. Let me know how that works for you.

I put all the keys and tokens in and im still getting this:

1146 - Table 'fishkrib_ebay.configuration' doesn't exist

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[TEP STOP]

[maxrisc]

A general update on where I am with things as I know it has been a while since I turned out some code.

There is new web based installer which is simplified for installation. I have removed the category installer and I am integrating this into the back end admin so different countries can use it and it will make the initial download smaller.

.htpasswd will no longer be needed and the admin interface has been secured by
username/password which is specified during installation. (There is no automatic reset for this yet so don't lose your passwords)

I have integrated some AJAX functionality into auctions.php and I am adding multiple account support for listing. This will let you manage several accounts and keys from your admin configuration screen. I have toasted the ebay.config.php nightmare that a lot of people have experienced. You will need to add your accounts for testing in your Configuration->Users screen.

I am trying to squeeze in basic shipping information but it might not make it to this next release. We'll see.

There are still some more things to do but hopefully this will be out the door soon. I will be putting it up for testing on my site. Once several people have reviewed it and we have worked out any issues then I will release it for the general public.

And of course documentation....lovely documentation. I am trying to get that sorted as I go along. There are links back to my site where I am compiling everything I have into a book using pages.

Email checkout has been removed from core and put into it's own package. Once 0.5.4 is released email checkout should follow. Hopefully this will be done very quickly as I know there are a lot of xmas sales coming up.