PHP Portfolio

Zen Cart Add Model Number For Attributes

I customized Zen Cart attributes to be able to add a model number for each attribute. Searching through the forums, I see many people were looking for this modification, but none had been written.

The problem was that the client had products of various sizes, all with different item numbers. When the order confirmation email was sent, the parent product item number was included, but the attribute item number that was purchased was not.

I modified code to be able to assign a model number (or item number, sku…) to each attribute created for a parent product. This number was added to the attributes code on the product info display page, throughout the checkout process, and in the order confirmation email. It was also added to display on the order history page.

The client had about 1000 attributes, so instead of manually editing each product in the admin tool, I exported all data into a spreadsheet so they could add all model numbers in place, and then wrote a script to import this new data. This saved the client many hours of data entry.

Export Zen Cart Customers

This script was coded to export Zen Cart customers. The client wanted a simple script to export all customers from the database. The admin tool output all data to the browser. A link was also included to download the data into Excel. Clicking the link generated an Excel file that automatically opened instead of having to save a text file and import the data into Excel.

Redirect Page Based on Users Country

For this small PHP project, the client needed code to find what country the user was located so they could be redirected to the appropriate web page.

I wrote a simple PHP script to find the country code the user was located and then redirect to the needed web page.

Added PHP Captcha To Form

I hade added reCaptcha image verification to the clients Article Friendly article directory script due to teh amount of spam he was getting on his signup form. This worked for a while, but then spammers wrote scripts to crack recaptcha and auto submit. I added text captcha to the form to stop spam from getting through.

Also this week, I added text captcha form verification to several other clients’ PHPforms. They were using Java Script validation on the web page. This is easily bypassed by simply disabling Java Script . Using PHP to validate the form data on the server side, it is much harder for spam to get through.

WordPress WP e-commerce Category Importer Bug Fixes

This client came to me to fix bugs on his WordPress shopping cart website using WP e-commerce. He had about 1,000 products to import and had purchased a category importer plugin to import all of the products. Products were importing successfully, but the parent child relationship for the categories was very buggy. Products were getting assigned to multiple incorrect categories, and display in the admin tool was not showing the category and subcategory relationship. I managed to fix the display issues in the edit product tool, but had recommended that the client have the developer fix the importer bugs since it was a paid plugin.

The client was on a tight deadline at this point, and the bug was not getting fixed. As a quick solution, I created an admin tool to be able to fix the data. Products were output in groups of 100, showing the product, and all of the assigned categories. Manually reviewing each product, the client could then click on all incorrect categories and remove them with one submit, instead of having to edit each product individually. This saved the client many hours of work and was able to meet his deadline to release the website.