Solved

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

Posted on 2007-11-29
8
461 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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
Every business owner understands the significance of online customer reviews and the impact it can have on sales and revenues. With technology advancing at such a rapid pace, getting online reviews has never been easier, especially when many regions…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to count occurrences of each item in an array.

760 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

23 Experts available now in Live!

Get 1:1 Help Now