[Pro] Web Shop, MySQL questions!

Hi there,

I have produced e-shops with Mals in the past and had no probs with the way it all works. A client of mine wants to introduce an e-shop to their site (produced in Freeway) and basically they have thousands of products they wish to add…

Now I am guessing the best way of doing this is by putting all the products on a MySQL database. Not having any experience of MySQL… how easy is it to use? How easy is it to integrate with Mals/Freeway and how easy is it to make changes?? Are there any decent tutorials out there regards this??

Is there a way I can get the client to produce as much of the information as poss and then to integrate into a template of sorts created by me? Or should I consider a different online shopping cart altogether?

Sorry for so many questions… but I am a bit flummoxed as to what to do.

Cheers for your help in advance.

Jon


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Hi Jon,
Use OptionCart (http://www.optioncart.com). It’s cheap, easy to set up
and run and integrates fully with Mals. The products are all held in a
database so your client can add, edit and delete products as they see
fit. You can even use Freeway to design your own ‘skin’ for the store
or simply alter one of the supplied templates.
Update: It appears you can’t buy OptionCart directly from the
developers and need to either buy it from one of their resellers or
become a reseller yourself. See;
http://www.optioncart.com/authorized.htm
and;
Purchase OptionCart Deluxe or SiteBuilder eCommerce Software | Smartlab Software
Regards,
Tim.

On 15 Jul 2009, at 14:38, wingnut wrote:

Hi there,

I have produced e-shops with Mals in the past and had no probs with
the way it all works. A client of mine wants to introduce an e-shop
to their site (produced in Freeway) and basically they have
thousands of products they wish to add…

Now I am guessing the best way of doing this is by putting all the
products on a MySQL database. Not having any experience of MySQL…
how easy is it to use? How easy is it to integrate with Mals/Freeway
and how easy is it to make changes?? Are there any decent tutorials
out there regards this??

Is there a way I can get the client to produce as much of the
information as poss and then to integrate into a template of sorts
created by me? Or should I consider a different online shopping cart
altogether?

Sorry for so many questions… but I am a bit flummoxed as to what
to do.

Cheers for your help in advance.

Jon


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

FreewayActions.com - Freeware and shareware actions for Freeway
Express & Pro.

Protect your mailto links from being harvested by spambots with Anti
Spam.
Only available at FreewayActions.com

http://www.freewayactions.com


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Cheers Tim,

That sounds exactly the kind of thing I am looking for. The fact that the brunt of the work and updating can be done by my client is excellent - they’ll certainly appreciate it.

To sound a bit dim… how does it work exactly?.. I have had a skim read of the sites you pointed me to and I am a bit fuzzy as to how it integrates with Mals and Freeway. Will I need to know coding to get the Freeway site to access the database it produces or are there actions I’ll need to put into place when I construct the shop?

Thanks again

Jon


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Hi Jon,
What happens is that OptionCart gets installed on your server and uses
PHP and MySQL to store the product information in a database on the
server. The application contains areas for your client to log in
securely and enter product descriptions, prices, offers etc. These
then show up on the public side of the site as products in their
respective categories. From memory you can also add products to the
system that aren’t yet available to the public so that you can add
data as it becomes available. Once you add your Mals details (server
number and ID) OptionCart is ready to pass these products to Mals for
purchase.
If you are happy using the templates that get shipped with OptionCart
then you are pretty much done. I suspect you’ll want to customize
these to look like the rest of your site which is where pulling the
templates apart and inserting the required code as markup in Freeway
will come in handy.
If you get one of the OptionCart resellers to install the system for
you you’ll be up and running without needing to know anything
technical. Installation is easy enough, it just takes a little time
and a few passwords for the server.
Regards,
Tim.

On 15 Jul 2009, at 15:20, wingnut wrote:

Cheers Tim,

That sounds exactly the kind of thing I am looking for. The fact
that the brunt of the work and updating can be done by my client is
excellent - they’ll certainly appreciate it.

To sound a bit dim… how does it work exactly?.. I have had a
skim read of the sites you pointed me to and I am a bit fuzzy as to
how it integrates with Mals and Freeway. Will I need to know coding
to get the Freeway site to access the database it produces or are
there actions I’ll need to put into place when I construct the shop?

Thanks again

Jon

FreewayActions.com - Freeware and shareware actions for Freeway
Express & Pro.

Protect your mailto links from being harvested by spambots with Anti
Spam.
Only available at FreewayActions.com

http://www.freewayactions.com


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Cheers Tim,

That all makes sense… I’ll have a go and see what I can make of it - although, like you said, I’ll definitely be wanting to change the templates so they fit with the rest of the site design. Could well be here again in the future asking a few more questions though!!

Cheers again for your help

Jon


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

And here’s another PHP/MySQL cart that uses Mals and looks almost
identical to OptionCart;

Regards,
Tim.

On 16 Jul 2009, at 10:18, wingnut wrote:

Cheers Tim,

That all makes sense… I’ll have a go and see what I can make of it

  • although, like you said, I’ll definitely be wanting to change the
    templates so they fit with the rest of the site design. Could well
    be here again in the future asking a few more questions though!!

Cheers again for your help

Jon

FreewayActions.com - Freeware and shareware actions for Freeway
Express & Pro.

Protect your mailto links from being harvested by spambots with Anti
Spam.
Only available at FreewayActions.com

http://www.freewayactions.com


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options