New phpShop MAMBO Site

[Bruce Morgan]

I am the owner of http://www.pepper-passion.com and we recently switched our site over to the Mambo platform and phpShop.   We are very happy with the power and flixibility of the new platform and the switchover was relativley prblem free.

One big problem was trying to cut and paste whole pages of content from the old site and recreate the links and then clean up all the extraneous html code that was created in the process..  I would not say that the code is \"clean\" but it seems to work.  Weare pretty happy but would like to work out a few bugs as follows:

1.  The multiple tax rates does not seem to work correctly as per my earlier post today.

2.  The top-ten module is out of whack (at least for us).  The products listed and ther order is completely wrong.

3.  I would like to be able to capture the customer information and be able to download it into my Access database or into my Quickbooks program.

4,  It would be great if there were a module where I could send a blanket emailing to my customer list, preferably using a front end program such as Outlook.

5.  We have not been able to implement search engine friendly URLs.  This has been a major frustration.

Take a look at our sight and let me know what you think.  If you know of any solutioons to the itmes listed above let me know

Thanks, Bruce

Post edited by: soeren, at: 2005/01/23 20:27

[Doug Gault]

Bruce.

I'm currently looking into extending the reporting capabilities of m-phpShop, and one of the things I'm researching is an extract file of all \"new'\" transactions to QuickBooks.

It may be a while before anything real and useful is available, but I'd like to get your ideas on what you would expect from such a module.

As for the blanket newsletter style mailing, look up \"YANC\" on mamboforge. Its an Automated Targeted Marketing component that allows you to manage lists, and send \"newsletters\" to people .....  

If I'm correct, the users in m-phpShop are an extension of the standard Mambo users, so this should work for your purposes.

[[ SOREN, Can you confirm that last statement? ]]

There is also, obviously, Soren's  LetterMan component (available on this site) that should more than fulfill your requirements  too.

Doug

Post edited by: dagdal1967, at: 2005/01/25 20:23

[Bruce Morgan]

Many Thanks.  I have not yet implemented Quickbooks so I am not really able to say which features I would need exactly.  One of the things that is slowing medown is that I ama one person business and I not only sell retail through the web site but I also manufacture and/or package most of the product I sell.

My educated guess is that I would need to have the order number, sku's for each item & qty, shipping amount, tax amount, customer contact information as well as ship-to information.  For my needs I could import this information manually and it would need to be done daily or weekly.  It is probably not an easy task which is why I would settle for a CSV file that I could import into my Access customer database if that were easier to implement.

I will check into the two programs you mention.  I would like to do occasional email newsletters supplemented with printed mailings a few times a year.  If I could do both by tapping into the same information base that would be ideal.

Thanks again.
Bruce

[Craig]

For now, why not use phpmyadmin to export the CSV data from the SQL? It is not that daunting - simply select the appropriate table and press export - and the options will be there in front of you.

[Bruce Morgan]

Okay, siund intewre3sting but coulf you help walk me through the process?  First, where do I find phpmyadmin?  Is it an add-on module?

Second, wheredo I look for the SQL data base?  

Sorry to sound so ignorant but I am new to all of this.

Bruce

[Bruce Morgan]

Since my first post I have found each each update of phpShop/VM to be useful.  Of all the limitations detailed above, the only one that remains is the multiple tax rate feature.  It seemingly does not yet have the ability to select a tax rate class based on the ship-to address.  This is a great product!

Bruce
www.pepper-passion.com