Personal tools

Gallery2:Modules:zencart

From Gallery Codex

Zencart Integration Module
Integrates Gallery2 and Zencart 1.3.9
Author: Dayo Akanji
Current version: 3.3.0
Gallery Version: Gallery 2.3.1
Download the module files here.
Download a patched version of Zencart 1.3.9f here.
This patched version has the module files required on the zencart side preintegrated and will make installation easier.
If you will rather use the official Zencart 1.3.9f Release and carry out all the required installation steps yourself, you can get it here.

Visit the Support Site for enquiries and support requests.


Contents

Requirements

  • Gallery 2.3.1
  • Zencart 1.3.9
  • Both must use the same database


Description

The Gallery2/Zencart integration module allows users to organize their photos and other multimedia files in Gallery2, a web-based photo album organizer, while simultaneously offering them for sale through Zencart, a powerful open source e-commerce application. This module was originally developed for Zencart 1.2.7 as part of Google's 2005 Summer of Code by Michael Rodriguez-Torrent. Additional work by Chuck Redman to update it for Zencart 1.3.7. Updates for Zencart 1.3.7 finalised by Dayo Akanji (24/10/2007). Updated for Zencart 1.3.8 (11/01/2008) and then for 1.3.9 (16/06/2010) by Dayo Akanji.

Features

  • Easy, painless, installation.
  • Return to previous Gallery2 page from any Zencart page
  • Items and albums from Gallery are automatically synchronized as products and categories in Zencart.
  • Set default options and pricing of Gallery products and use Zencart to customise individual items.
  • Comes with Gallery2 templates (Based on PGTheme Color Packs) that will also match most Gallery2 Themes or serve as a basis for customisation.


Installation

Notes

  • Uninstall any versions of the module predating Version 3.0.0 in Gallery2 Admin first if you have one installed.
    • You will lose your Zencart configuration after you do this!!
  • It is helpful to have the Rewrite Module active before installing this module.
  • Only actual data items (photos, movies etc) can be added to Zencart through this module. Albums cannot be added.

First, Install Zencart

  1. Download and unpack Zencart 1.3.9d into your Gallery2 folder and rename it as you wish to call your online store (e.g. mynewstore). This will allow you to have a directory structure such as wwww.yoursite.com/gallery/mynewstore.
  2. Launch your browser and navigate to the Zencart folder and follow the instructions to install it. Use the same database name as Gallery2, but use different a table prefix for the Zencart database.

Then, configure Zencart if not using the patched Zencart fileset

  1. Upload the contents of the "zencart" folder from this module package to the mynewstore folder.
  2. Log in to Zencart as Admin at "yoursite.com/gallery/mynewstore/admin".
  3. Select "Tools" >> "Template Selection" and choose one of the Gallery2 Integration Templates provided. Default G2 integrated Templates are PGCharcoal or PGSnow
  4. Select "Catalog >> Categories/Items >> New Category" and create a new category called "ZCG2".

Then, In Gallery2

  1. Upload the module files in "gallery2" to your Gallery2 modules directory.
  2. In your Gallery2 Site Administration, click on "Plugins," find "Zencart" under the "Commerce" heading, and click "Install"
  3. After Installation, click "Configure"
  4. Enter the full server path to your Zencart installation. E.G. "/home/you/public_html/Gallery2/mynewstore/".
    (NOTE: You must enter the full server path and not a relative path. Some features will fail if a relative path is used)
  5. Click "Save"
  6. Select "ZCG2" from the drop down menu after the page refreashes.
  7. Click "Save"
  8. Activate the module.
  9. Refresh the page and click on the Zencart link under "Admin Options" to edit product details
  10. Edit permissions for the individual items as you wish. The module will have assigned permissions to non album items on activation.
    (NOTE: To prevent items being bought, you will have to disable them in Zencart as the module adds all data items in your gallery to Zencart. You can also add password protection as described under "Access Control" below)

Finally, tweak the site settings in Zencart

  1. Replace "/mynewstore/includes/templates/pgxxx/images/logo.gif" with one for your site.
  2. Replace the line "Designed by Dayo Akanji" (and similar) with a suitable taglines for your site
  3. You can take a copy of the template folder (/mynewstore/includes/templates/pgxxx) and modify stylesheet.css to taste. If you do this, also create copies of "/mynewstore/includes/languages/pgxxx" and "/mynewstore/includes/languages/english/pgxxx" with the same name and case structure as the copy. Also edit "/mynewstore/includes/templates/pgxxx/template_info.php".
    (NOTE: Creating a custom template in this manner may result in updates to the module not being applied to your insallation. Similarly, if you edit in situ, updates may overwrite your changes)
  4. Read and apply the Zencart Tutorial on securing your Zencart installation.
    If you change the name of your Zencart admin folder as advised in the tutorial, you will need to make some changes to the g2 module code.
    To do this, go to "/gallery/modules/zencart" and open "ZenCartAbstraction.class". Change every instance of $this->_path . 'admin/xyz/xyz' to $this->_path . 'YourNewFolderName/xyz/xyz'.


General Notes

  • To add Gallery items to Zencart, simply add items to your Gallery.
  • To change default pricing and options, click on "Zencart" in your Site Administration menu.
  • The Product Category specified as the 'root' category for Gallery2 images should NOT be the top 'Main' category in the Zencart store.
  • All Gallery2 items are automatically given an item type of "Product-Gallery". If this is changed to a different category e.g. Product-Free or Product-Free Shipping, the Gallery connection will be broken.
  • The Gallery2 Bridge will coexist happily with the Zencart Image Handler and Lightbox Add On, but does NOT interact with them. i.e. they work with products added in the normal way in Zencart while the Gallery2 addon works with the images added in Gallery2.


Access Control

Password Protect Albums

  • To password protect an album...
  1. Open /mynewstore/includes/templates/pgxxx/common/tpl_check_albums.php.
  2. Edit "#_01" etc in 'case "#_01"' etc to reflect the cPath name of albums to be restricted.
  3. The cPath value can be found in the address bar after navigating to the album within Zencart eg "...&cPath=1_23".
  4. Edit each instance of $myusername, $mypassword, $areaname & $access_details as required.

Password Protect Individual Items

  • To password protect an item...
  1. Open /mynewstore/includes/templates/pgxxx/common/tpl_check_items.php.
  2. Edit "#_01" etc in 'case "#_01"' etc to reflect the products_id name of items to be restricted.
  3. The products_id value can be found in the address bar iafter navigating to the item within Zencart eg "...&products_id=123".
  4. Edit each instance of $myusername, $mypassword, $areaname & $access_details as required.


Troubleshooting

ProblemSolution
Help! I get a host of errors after trying to add images to my gallery with the module activated. If this is happening with an empty gallery and those are the first images being added, you are probably using a version before Version 3.1.0. If this is the case, upgrade to current version and try again. If the problem persists, deactivate or uninstall the module in Site Admin, add a couple of images to the gallery and then reactivate the module.
Help! Thumbnails for Gallery products are not displayed in Zencart in some instances. This may be caused by a limitation in Zencart which restricts the length of the thumbnail URL. As a result, if you are not using URL rewrite or if your Zencart and Gallery2 directories are particularly far away, the URLs may be too long and thumbnails will not be displayed. To correct this, try activating URL rewrite. Alternatively, or if URL rewrite does not solve the problem, do the following:
  1. Run this query on your Zencart database (where "PREFIX_" is your Zencart table prefix, generally "zen_"): ALTER TABLE `PREFIX_products` CHANGE `products_image` `products_image` VARCHAR (255)
  2. Check the "Enable long thumbnail URLs" box in the Zencart module options in Gallery2.
  3. Deactivate and reactivate the module to update the thumbnails in Zencart.
  4. The above ALTER may also be needed for the categories_image column of categories table.
Thumbnails for Gallery products are not displayed in Zencart at all. Make sure that Zencart is installed in a subdirectory of Gallery2.
Category thumbnails in Zencart are squashed or not the right size. Set your album thumbnails and your Zencart subcategory images to the same dimensions.
Items are added with a set quantity (9999) and I would like to offer an unlimited quantity (or a more limited quantity). Go to Gallery->Modules->Classes->GalleryZenCart.class and edit this line: "$data = array('products_quantity' => '9999.0',". Any new items you add should be imported into Zencart with the new quantity you set. To change existing items, run this query on your Zencart database (where "PREFIX_" is your Zencart table prefix, generally "zen_" & MY_QTY is the quantity you wish to assign as default): UPDATE `PREFIX_products` SET products_quantity = 'MY_QTY' where products_id = '*'.
The order list only shows me the item title. Some of my items have the same title and I'd like to know where to find the right one. Please give your items unique titles. Every store has to have unique id numbers for items and since you are running a store, you have to do the same or things will descend into chaos. Note that a unque ID is appended to the item in Zencart though.
I tried to change my integration category from Top to a subcategory and it moved all my categories, even non-Gallery ones. Change back to Top, deactivate, uninstall, and reinstall the module. Configure with your new category and reactivate the module.
I deactivated the module and deleted the integration category in Zencart and now I can't reactivate the module to change it. Uninstall the module, reinstall, and configure with your new category choice. Delete the integration category only after you have selected a new one or have uninstalled the module.
I want to set pricing per-item, offer a sale on a item, remove an option from an item etc. Go to your Zencart administration and edit the item as you would any other product. All custom pricing, options, and values you apply will remain until you uninstall the module. Please note that any custom quantities will be reset if the module is deactivated and reactivated.
I have general or synchronization problems. Deactivating and reactivating the module in Gallery will resynchronize your entire Gallery with their Zencart Items and should cure any synchronization problems that have occurred for any reason (please report bugs!).
Things are getting really ugly.
  1. unistall the module in Gallery2
  2. delete the Zencart category that held the Gallery2 products
  3. using your favourite database management software such as phpMyAdmin, delete all entries beginning with "zc_" (or whatever your Zencart Table Prefix is) in your Gallery2 ExternalIdMap table.
  4. Finally, reinstall the module in Gallery2.

Uninstall

  1. In your Gallery2 Site Administration, click on "Modules," find "Zencart" under the "Commerce" heading, and click "deactivate."
  2. Click "uninstall" next to "Zencart" in the module list.
  3. Optionally, delete the module files that you uploaded when installing.
Retrieved from "http://codex.gallery2.org/Gallery2:Modules:zencart"
advertisements