» Software

Feedback from users prompted me to add an extra column to the report display… the master category. The master_category_id is listed in the products table and is generally the category the product was originally created in (unless changed later). The report won’t show every category a product is listed in if the product has been linked to multiple categories.

Download ZenCart Inventory Report

Thanks to Ron for the donation to help out with these feature additions.

Popularity: 26%

Share This

Editing a post is a necessity from time to time, especially with any type of coding related blog. I particularly like to keep older posts up to date with revised download links as new versions are released. This prevents a user following a link off of a search engine to an old post and downloading an old version of one of my pieces of code. Surprisingly, I could not find a Wordpress plugin to do just this. This tiny plugin allows you to attach timestamped revision tags to a post using the Wordpress metadata system.

For an example in action see the Post History heading after this post.

Installation

1. Download and unzip wp_revision_history.zip
2. Upload revision_history.php to your Wordpress wp-content/plugins/ directory.
3. Add the following CSS to your stylesheet. Change CSS to match your site layout.
   #revision-date  {
           padding: 3px 5px 3px 12px;
           font-weight: bold;
           color: #333;
   }

   #revision       {
           padding: 2px 5px 8px 18px;
           color: #555;

   }

4. Add the following snippet to your template where you want a post's revision
   history to display
   <?php if(function_exists('wp_has_history') && wp_has_history())   {  ?>
   <h3>Post History</h3>
   <div class="cmeta" style="bottom-margin: 20px;" id="history">
   <?php wp_history(); ?> 
   </div>
   <? } ?>

Usage

To add a revision tag to a post, add a new custom field named 'history' to the post. Set the custom field's value to the revision note text. Multiple revision tags may be made to the same post by adding more custom fields with the key 'history'. Each note will be automatically timestamped. The history listing will be sorted by the timestamp value.

Download Wordpress Revision History

Popularity: 27%

Share This

Here’s a simple admin report for ZenCart that will generate an inventory report with per product totals and a report total. The report may be paginated or generated over the whole catalog.

The report was created by modifying the ZenCart default Products Viewed report. It was created from the ZenCart v1.2x source but has been installed on v1.3x versions. This is the first release, so any problems please comment below.

In future updates, I would like to allow for CSV export as well as reporting by category.

To install, simply unzip and upload to your main ZenCart install directory.

View all releaseas

Popularity: 33%

Share This

The ZenCart default reports are sufficient for most uses, but with many products pages of results are a pain to look through. Adding a search is pretty simple. The example below adds a search to the products purchased report:

Add the search box and form:
admin/stats_products_purchased.php Line ~#64

BEFORE:

AFTER:

Add the processing to the query:
admin/stats_products_purchased.php Line ~#84

BEFORE:

AFTER:

This simple mod will search the products_id and products_name fields. Adding a search to the other reports is similar. One only needs to adjust the query to match the applicable fields for the report.

Popularity: 19%

Share This

I developed a quantity by attribute modification for ZenCart for a client about six months ago. It has been working very well for them, but it only supports simple attributes. Size OR color OR fabric not size AND color or size AND fabric. The complexity and time involved with maintaining such a detailed inventory of their 1,000’s of products steered us both away from that. Instead they were able to make intelligent choices on which attribute to track for a given type of product so that their inventories are very close without the added complexity.

An example:
http://www.pimpcostumes.com/…/Hos-Sexy-Shoes/Sexy-Heels-Orbit-Red/643,139

The size select box should have some items that show as low stock.

Thanks to another client who needed a similar modification, I was able to more generalize the mod more and roll it into a contribution for ZenCart.

Download zencart_attributes_quantity.zip

This is a first draft release, so if you find any issues, please forward me your Zencart version, the issue you encountered and a solution if you found one.

Popularity: 31%

Share This

The ZenCart Sales Report contribution allows a site owner to easily and quickly generate sales reports with many different filters. The one missing filter was a state or local zone filter. This filter would be useful for figuring out total local sales for state sales tax purposes.

I have updated the contribution to include this filter.

Thanks to Frank Koehl for the orignal contribution.

Download zen_sales_report_v1.4.1.zip

Popularity: 25%

Share This