Solved

Does anyone know about Shopping Cart (PPCal) (www.shoppingcart.org)

Posted on 2007-11-29
8
462 Views
Last Modified: 2013-12-25
I have brought this shopping cart software & the vendor is quite slow at answering questions & therfore wanted to see if anyone on here know about it, so that I can ask them questions about intergrating the cart into my site.  Mainly, stuff like how could I display "sold", etc on my page and not within the shopping cart shop front,

Therefore can anyone help?
0
Comment
Question by:creativepresence
  • 5
  • 3
8 Comments
 

Author Comment

by:creativepresence
ID: 20375228
building on ,y question...

I am using a shopping cart called PPCal (shoppingcart.org) that is perl/cgi based and uses a flat file database.  It comes with its own shop front, but also you can intergrate its add to cart & view cart buttons into your site, but I also want to get other stuff displayed such as total items per catorgory or if the item is sold.  Does anyone know if its possible & if so, how?
0
 
LVL 17

Expert Comment

by:mjcoyne
ID: 20381225
Since the requirements for the PPCal shopping cart are Perl and CGI, I think we can assume the application is written in Perl.  However, this is a commercial product (as in not open source), which might limit our ability to help you customize it.

When you purchase it, do you get the Perl source code, or a compliled binary application?  If you get the source code, anything's possible.  If you get a binary executable, the ability to alter the behavior and output is severly limited.

However, since it uses a database, there's no reason we couldn't access that database separately from the application and extract information about total items sold or total items per category, provided that information is stored in the database.  Maybe with a few Perl scripts and some CSS, you could alter the HTML displaied.

So, in a nutshell -- if you have the CGI source code, customization is easy (well, easier anyway) and pretty much unlimited; if you don't have the source code, customization is limited and difficult.
0
 

Author Comment

by:creativepresence
ID: 20385977
Hi, thanks for replying.  I have the cgi & pl files, so i take it thats the source code. The developer gives the impression that they are open to letting people customise the cart, plus their support is non-existant.  They have provided some coding that will display a "view cart" button that, well views that cart & "add to cart" and i have got these both working on my site, but also want other database items.    I have tried to figure it out, but being a noob, couldnt.  Although i have identified some special tags such as <!title>, etc, but dont know how to call them.
0
 

Author Comment

by:creativepresence
ID: 20392162
I have now had contact from the developer & have managed to resolve most isues, but would really like to be able to display database values outside of the cart shopfront.  Anyone?
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 17

Expert Comment

by:mjcoyne
ID: 20395482
We'll need to know much more about the program than you've told us...  A problem that might come up is that this is proprietary code, and thus you're probably not allowed to post it here...

To advise you on how "to display database values outside of the cart shopfront", we would need to see the code driving both the database and the shopfront, and be familiar with the structure and type of database used, and be familiar with the HTML that is currently output by the program.

I'm not sure how we can gain that familiarity without posting copyrighted code...
0
 

Author Comment

by:creativepresence
ID: 20395732
Hi, I have been workign hard to provide you with as much info as possible & have located the txt file that contains the data that I need displayed without having to show you any of the apps inners.

1|halffrag|1|8001|9004|HalfFrag|10.00||1|||1|||||.00||.00|||1,
2|FullFrag|1|8001|9005|FullFrag|10.00||1|||1|||||.00||.00|||1,
3|DoubleFrag|1|8001|9006|DoubleFrag|10.00||1|||1|||||.00||.00|||1,
4|Colony|1|8001|9007|Colony|10.00||1|||1|||||.00||.00|||1,

One of my requirments is to display on my home page the number of item in a catogory.  The value can be seen in the first coloum, therefore currently there is 1 item in each of the catogories.  Therefore is it possible to display on the front page the number of items in catogoy "1"?
0
 
LVL 17

Accepted Solution

by:
mjcoyne earned 120 total points
ID: 20398757
It's easy to extract the data.  Say for example the data you've provided above is held in a text file called my_text_file.txt.  I'm also asumming you mean that the *third* column holds the number of items in the category identified by the name in the second column.  If that's the case, then:

#!/usr/bin/perl -w
use strict;

my %categories;

open (IN, "my_text_file.txt") or die "Couldn't open my_text_file.txt: $!\n";

while (<IN>) {
    my @temp = split /\|/;
    $categories{$temp[1]} = $temp[2];
}

foreach my $category (sort keys %categories) {
    print "Category: $category, Quantity: $categories{$category}\n";
}

outputs:

Category: Colony, Quantity: 1
Category: DoubleFrag, Quantity: 1
Category: FullFrag, Quantity: 1
Category: halffrag, Quantity: 1

So, extracting and printing the data is no problem.  Nor is it any problem to print it out as HTML, rather than just text, as I've done here.  The problem comes up with integrating the new HTML with the old, something that will need to be worked out with reference to the source code.
0
 

Author Closing Comment

by:creativepresence
ID: 31411698
Hi, i have actually resolved this problem with a PHP solution, but thanks anyway.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Batch, VBS, and scripts in general are incredibly useful for repetitive tasks.  Some tasks can take a while to complete and it can be annoying to check back only to discover that your script finished 5 minutes ago.  Some scripts may complete nearly …
I have been pestered over the years to produce and distribute regular data extracts, and often the request have explicitly requested the data be emailed as an Excel attachement; specifically Excel, as it appears: CSV files confuse (no Red or Green h…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now