cpgShop - a PayPal shopping cart

[Stramm]

cpgShop - a PayPal shopping cart.
Updated: 11.11.2010 - actual version cpgShop 1.0.1
Updated: 04.11.2011 - actual version cpgShop 1.0.3
Updated: 15.07.2012 - actual version cpgShop 1.0.4
Updated: 03.09.2016 - full version cpgShop 1.0.4 added

Changes in 1.0.4:
- changed: cart saved in the db instead of the cookie to avoid limitations (cookie is just used to identify the cart)
- added: support for free items
- added: possibility to chose where to redirect after adding an item (cart or back to the picture)
- added: users can save their cart as draft (admin can set lifetime and number)


This plugin is based on the beta cpgmart plugin that has been coded by foulu for cpg 1.4x some years back.

Here are some of it's features.

• Sell downloadable pictures
• Downloadable content resized on the fly
• Password protected download folders
• Sell for print pictures
• Various shipping methods
• Additional shipping fees for certain prices
• Additional shipping fees for differnt countries
• PayPal support
• PayPal IPN
• PayPal IPN logging
• Encrypted PayPal buttons
• Cash on delivery support
• Wire transfer
• Item options
• Discounts (codes)
• Customer needs to agree to TOS (optional)
• Modified register page with mandatory address fields
• Modified profile page to reflect this new fields
• Easily make these fields not mandatory
• All email templates can be modified in a web backend
• Invoices (text, html, pdf)
• Customer can be informed about order state changes
• Workflow with virtual folders - incoming, paid, printed, processed.
• On status changes orders can automatically be moved into their corresponding folders.
• Customer has a order history
• Customer can check the order status
• Customer has the possibility to resend his download password and invoice
• Customer can cancel orders as long the order state has not changed from incoming
• Admin can lock the download folder
• Admin can resend the download password
• Admin can resend the invoice
• Admin can delete the download folder

Just try it and see what this plugin can do for you.

Currently this language files are included
- english (I hope some native english speaker will correct my wording)
- german

The plugin in its basic version doesn't come with PayPal IPN nor with digital image download support.
For a donation I'll send you the full version. Just leave a message here and I will contact you using the forums private messaging system.

I've removed the basic version and uploaded the full version. Please have a look at the attached txt file for a short introduction how to setup PayPAl IPN. Have fun.

Please use this thread for your suggestions and ideas. Of course you can ask questions here as well or post if you have problems.

[ReVoX]

I can't download It. It say Unauthorized.

[Stramm]

I've attached it to the announcement thread.

[taucher_0815]

Any changes to the last version I got?

[Stramm]

Some minor fixes. Please have a look at the changelog.

[ReVoX]

Thanks for your hard work Stramm. I will test It as soon as possible.

[dshelley]

Stramm - thanks so much for your work on this plug-in.

I've started testing it out and have one challenge and one suggestion:

Challenge - I believe that I have configured everything properly - created 2 prices, 1 price set, 1 option and one option set. Then I enabled the shop and configured 1 album to have the price set and option set. When viewing a photo, I can see the Add Image to Shopping basket button but the drop down list doesn't have any prices/options in it. I realize this is a terse description, but any idea what I'm doing wrong?

Suggestion - I don't know if this is theme related or not but all my ADMIN MODE functions use the <div ...> tag instead of <li ..> so they show up as buttons instead of plain text links. i.e. in the function cpgshop_config_button could you use <div class="admin_menu admin_float"> instead of <li>?

Thanks
Doug

[taucher_0815]

Challenge - I believe that I have configured everything properly - created 2 prices, 1 price set, 1 option and one option set. Then I enabled the shop and configured 1 album to have the price set and option set. When viewing a photo, I can see the Add Image to Shopping basket button but the drop down list doesn't have any prices/options in it. I realize this is a terse description, but any idea what I'm doing wrong?

Have you set a downloadable product? There is a check implemented if the downloaded image size is smaller then the size for the downloaded product. In this case no product is selectable.

[Stramm]

To make th first steps with the shop start it simple. Use 'print' images, add three prices and group them into a set. Later add options, set some prices for downloads etc.

At that time I suggest to restart with prices and a group. If the problem persists, let me know.

[dshelley]

Thanks for the feedback. I have deleted the options and option set and now have 3 prices and 1 price set. The prices are all set to type = "ship".

I'm still getting a blank dropdown on the photos that have the shop enabled.

Any other things I can look at to troubleshoot this?

thx
Doug

[Stramm]

Can you export your shop settings (phpmyadmin), zip them and add the file to your next post. I'll see if  I can reproduce that behaviour here.

[dshelley]

Attached is a phpMyAdmin export from all the "cpgshop" tables.

Thanks for your help
Doug

[Stramm]

I have had a look at your sql and you haven't properly created the price set, you've created an empty one. Edit the price set and in the  multiselect box select the prices you want to use in that set (use ctrl to select more than one price).

[JoelFan]

Hi Stramm, thanks for creating this plugin! I'm looking into the documentation now, but I just have one question:

Can this plugin be used to make CPG sort of a regular shopping cart for standard products? In other words - if I have a CPG full of pictures of t-shirts, could I reasonably use this plugin to allow people to order the shirts that they see in the pictures?

Thank you!

[Stramm]

yes

[johnbcheetah]

Any buddhists amongst you??  I need your patience and understanding. Stramm, I installed the download (cpgShop for cpg1.5)at the bottom of your thread into the Plugins, then went through admin to install it and now it's blocked up completely and I can't get into my site on www.pictorious.fi/coppermine! On the Mac it just says:
Fatal error: require_once() [function.require]: Failed opening required 'plugins/cpgshop/include/init.inc.php' (include_path='.:') in /var/www/vhosts/pictorious.fi/httpdocs/coppermine/plugins/cpgshop-2/codebase.php on line 167

On Windows it says nothing at all.  I really don't know what corrupted what, but has anyone had this problem? My web host says he'll try to look at it tomorrow (he'll have to because my site is blocked), but it sure would help if someone knew the solution to this.
Many thanks, I hope there's a simple solution, I'm not good at this!
John

[Stramm]

Make sure you uploaded all files keeping the folder structure intact.
Don't play with pathes, cpgshop-2 won't work.

[johnbcheetah]

Thanks very much, that sorted that out! (cpgshop-2 was renamed automatically because I had previously downloaded it already).
But now I get
"There was an error while processing a database query"
would this be the last hindrance or can there be more? Should I wait until all the bugs are found and exterminated? I don't want to be a burden here, though i really would like this brilliant plugin installed.
Thanks!

John

[Stramm]

Uninstall the plugin using the plugin manager. Opt to delete the shops database. The reinstall the shop.
If the problem still occurs, enable debug mode and post the detailed error message.

[johnbcheetah]

The problem persists, this is the message, followed by the details.

Critical error

There was an error while processing a database query.

While executing query 'INSERT INTO cpg15x_plugins (name, path, priority) VALUES ('cpgShop', 'cpgshop', 1)' in include/plugin_api.inc.php on line 443 mySQL error: Duplicate entry 'cpgShop' for key 2


File: /var/www/vhosts/pictorious.fi/httpdocs/coppermine/include/functions.inc.php - Line: 263




USER:
------------------
Array
(
    [ID] => d71abf630eb8e9936a4f4a81ed39c159
    [lang] => english_gb
    [liv] => Array
        (
           

• => 22
              [1] => 260
              [2] => 16
              [3] => 281
              [4] => 124
          )
  
      [liv_a] => Array
          (
             
• => 1
              [1] => 3
          )
  
      [am] => 1
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
      [user_id] => 3
      [user_name] => admin
      [groups] => Array
          (
             
• => 1
          )
  
      [disk_max] => 0
      [disk_min] => 0
      [can_rate_pictures] => 1
      [can_send_ecards] => 1
      [can_post_comments] => 1
      [can_upload_pictures] => 1
      [can_create_albums] => 1
      [has_admin_access] => 1
      [access_level] => 3
      [pub_upl_need_approval] => 0
      [priv_upl_need_approval] => 0
      [group_name] => Administrators
      [group_quota] => 0
      [can_see_all_albums] => 1
      [group_id] => 1
      [allowed_albums] => Array
          (
          )
  
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT name, value FROM cpg15x_config [include/init.inc.php:181] (1 ms)
      [1] => SELECT * FROM cpg15x_plugins ORDER BY priority [include/plugin_api.inc.php:53] (0 ms)
      [2] => SELECT user_id, time FROM `houseof_coppermine`.cpg15x_sessions WHERE session_id = '406389730cd92c290e174432efb44d8a' [bridge/coppermine.inc.php:264] (0 ms)
      [3] => SELECT user_id, user_password FROM `houseof_coppermine`.cpg15x_users WHERE user_id = 3 [bridge/coppermine.inc.php:276] (1 ms)
      [4] => SELECT u.user_id AS id, u.user_name AS username, user_password AS password, u.user_group AS group_id FROM `houseof_coppermine`.cpg15x_users AS u LEFT JOIN `houseof_coppermine`.cpg15x_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='3' [bridge/udb_base.inc.php:70] (0 ms)
      [5] => SELECT user_group_list FROM `houseof_coppermine`.cpg15x_users AS u WHERE user_id='3' AND user_group_list <> '' [bridge/coppermine.inc.php:202] (0 ms)
      [6] => SELECT MAX(group_quota) AS disk_max, MIN(group_quota) AS disk_min, MAX(can_rate_pictures) AS can_rate_pictures, MAX(can_send_ecards) AS can_send_ecards, MAX(can_post_comments) AS can_post_comments, MAX(can_upload_pictures) AS can_upload_pictures, MAX(can_create_albums) AS can_create_albums, MAX(has_admin_access) AS has_admin_access, MAX(access_level) AS access_level, MIN(pub_upl_need_approval) AS pub_upl_need_approval, MIN( priv_upl_need_approval) AS  priv_upl_need_approval FROM cpg15x_usergroups WHERE group_id in (1) [bridge/udb_base.inc.php:321] (0 ms)
      [7] => SELECT group_name FROM  cpg15x_usergroups WHERE group_id= 1 [bridge/udb_base.inc.php:325] (0 ms)
      [8] => SELECT lang_id FROM cpg15x_languages WHERE enabled='YES' [include/init.inc.php:329] (0 ms)
      [9] => SELECT user_favpics FROM cpg15x_favpics WHERE user_id = 3 [include/init.inc.php:387] (0 ms)
      [10] => DELETE FROM cpg15x_banned WHERE expiry < '2010-11-02 10:45:53' [include/init.inc.php:443] (0 ms)
      [11] => SELECT null FROM cpg15x_banned WHERE (user_id=3 OR '85.157.63.207' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:459] (0 ms)
      [12] => SELECT plugin_id FROM cpg15x_plugins WHERE path = 'cpgshop' [include/plugin_api.inc.php:126] (0 ms)
      [13] => SELECT priority FROM cpg15x_plugins ORDER BY priority DESC LIMIT 1 [include/plugin_api.inc.php:409] (0 ms)
      [14] => INSERT INTO cpg15x_plugins (name, path, priority) VALUES ('cpgShop', 'cpgshop', 1) [include/plugin_api.inc.php:443] (0 ms)
      [15] => SELECT COUNT(*) FROM cpg15x_pictures WHERE approved = 'NO' [include/functions.inc.php:2409] (0 ms)
      [16] => SELECT lang_id, abbr FROM cpg15x_languages WHERE available='YES' AND enabled='YES' [include/themes.inc.php:2315] (0 ms)
      [17] => DELETE FROM cpg15x_temp_messages WHERE time < 1288683953 [include/functions.inc.php:4911] (0 ms)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
      [op] => install
      [p] => cpgshop
      [form_token] => 8fb94634e83a4581d1ac528ff8a6f394
      [timestamp] => 1288687435
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
      [submit] => Start
  )
  
  ==========================
  COOKIE :
  ------------------
  Array
  (
      [cpg15x_data] => YTo1OntzOjI6IklEIjtzOjMyOiJkNzFhYmY2MzBlYjhlOTkzNmE0ZjRhODFlZDM5YzE1OSI7czo0OiJsYW5nIjtzOjEwOiJlbmdsaXNoX2diIjtzOjM6ImxpdiI7YTo1OntpOjA7czoyOiIyMiI7aToxO3M6MzoiMjYwIjtpOjI7czoyOiIxNiI7aTozO3M6MzoiMjgxIjtpOjQ7czozOiIxMjQiO31zOjU6Imxpdl9hIjthOjI6e2k6MDtpOjE7aToxO2k6Mzt9czoyOiJhbSI7aToxO30=
      [901bfa47740504b5573f84bf3682e627] => 40298c25ac5e60e07a99fd8bf2e5ebde
      [9cb46d58df87746d331d2ced374fcf1f] => 15dece0571347b8f3b185eaac6c55c51
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version        5.3.3-0.dotdeb.1      OK   
  MySQL version      5.0.51a-24+lenny4-log OK   
  Coppermine version 1.5.8                 stable
  
  ==========================
  Module: GD
  ------------------
  Exact version                    2.0.34                     
  GD Version                       bundled (2.0.34 compatible)
  FreeType Support                 1                         
  FreeType Linkage                 with freetype             
  T1Lib Support                    1                         
  GIF Read Support                 1                         
  GIF Create Support               1                         
  JPEG Support                     1                         
  PNG Support                      1                         
  WBMP Support                     1                         
  XPM Support                      1                         
  XBM Support                      1                         
  JIS-mapped Japanese Font Support                           
  
  ==========================
  Key config settings
  ------------------
  site_url             http://pictorious.fi/coppermine/
  charset              utf-8                           
  allow_private_albums 1                               
  cookie_name          cpg15x                         
  cookie_path          /                               
  impath               /                               
  lang                 english_gb                     
  main_page_layout     catlist/alblist                 
  silly_safe_mode      0                               
  smtp_host                                           
  theme                rainy_day                       
  thumb_method         gd2                             
  
  ==========================
  Plugins
  ------------------
  Name           cpgShop                                                                                                                 
  Actions        plugin_install, plugin_configure, plugin_uninstall, plugin_cleanup, page_start, profile_display_form, profile_submit_form
  Filters        register_form_create, register_form_submit, admin_menu, gallery_header, gallery_footer, file_data                       
  --------------
  
  ==========================
  Server restrictions
  ------------------
  safe_mode                0                                         
  safe_mode_exec_dir                                                 
  safe_mode_gid                                                       
  safe_mode_include_dir                                               
  sql.safe_mode                                                       
  disable_functions                                                   
  file_uploads             1                                         
  include_path             .:                                         
  open_basedir             /var/www/vhosts/pictorious.fi/httpdocs:/tmp
  allow_url_fopen          1                                         
  max_execution_time       60                                         
  max_input_time           120                                       
  upload_max_filesize      20M                                       
  post_max_size            21M                                       
  memory_limit             256M                                       
  suhosin.post.max_vars    1000                                       
  suhosin.request.max_vars 1000                                       
  
  
  ==========================
  Page (performance)
  ------------------
  Parameter        Current  Peak   
  Memory usage     5.30 MiB 7.32 MiB
  Page generation  38 ms    38 ms   
  Page query time  2 ms     2 ms   
  Page query count 18       18     
  
  
  ==========================