Moneris Hosted Paypage Payment Module

Moneris eselect hosted paypage payment module has been upgraded to include several features users has requested. New features include language support, automatic Canadian store tax configuration selection, database log of error for troubleshooting ans process improvement. etc.

Moneris Solutions eSelect Plus Hosted Paypage Payment Module
Moneris eSELECTplus Hosted Paypage
Moneris PCI Compliance

Advanced Sales Reports for CRE Loaded, Oscommerce, Zen Cart, etc

Advanced Sales Report presents a report listing each order by date, order id, product(s) name, order sub total, tax, shipping costs, discount, order total?  Advanced Sales Report can be filtered by date, products and any other custom filters. Advanced Sales Report is excellent for tax/accounting and bookkeeping purposes.  A screen shot of Advanced Sales Report is provided. Advanced Sales Report is available for CRE Loaded, Classic Oscommerce, Zen Cart, etc.

advanced sales report for tax & bookeeping

advanced sales report for tax & bookeeping

Fulex Order Fulfillment & Product Warehousing Services For Cre Loaded, Zen Cart, Oscommers

Fulex Order Fulfillment & Product Warehousing Services provides warehouse space for storage of products awaiting packaging and delivery. Fulex also provides direct shipping of purchased product to customers there by removing stress and hassle surrounding packing and shipping to customers. Fulex through CIO Direct – Order Fulfillment, Warehouse Management and Customer Service – provides API for sending orders directly to Fulex as soon as orders are placed and paid for by customers; this API works on any oscommerce based store.

Site using Fulex Order Fulfillment & Product Warehousing Services www.round5mma.com

Edit Easy Populate to Add New/Extra Fields

Before you go about editing easy populate to add extra fields, an important decision has to be made. In which table are these extra fields going to be located? In Product table or in a separate table?

Adding new/extra fields to the products table is simpler compare to adding new/extra fields to a separate table.

Adding easy populate new/extra fields to the products table

0. Backup your database and your file.

1. Create new/extra fields in the products table. This can be done directly through phpMyAdmin if you have direct access to your database or through scripting in case you don’t.

2. Edit easy populate import.

ep1ep2ep3

3. Edit easy populate export

4. Test to confirm changes

Adding easy populate new/extra fields to a separate table

Schedule scripts to run at pre-set time with phpJobScheduler

I came across phpJobScheduler when working on site where the hosting company does not allow cron for scheduling jobs. The software is very easy to install and its performance is very impressive. Most importantly phpJobScheduler is free and there is support available through online documentation and forum.

Separating Canadian Provincial Sales Tax (PST) and Goods and Services Tax (GST/HST)

Here are screen shots showing separated Canadian Provincial Sales Tax (PST) and Goods and Services Tax (GST/HST) for Alberta and Quebec. Set-up and programming was done according to Canada Revenue Agency (CRA) Information.


Alberta Provincial Sales Tax (PST) and Goods and Services Tax (GST/HST)


Quebec Provincial Sales Tax (PST) and Goods and Services Tax (GST/HST). Quebec calculation is compounded.

XML Shipping Rates API from Shipwire

shipwire xml shipping rates

shipwire xml shipping rates

Shipwire XML shipping Rates API integration is now available for all oscommerce based shopping cart. Free demonstration and reference to live site using this module is avaiblae upon request. If you are a Shipwire customer this is a good module to add to your site because it provides accurate shipping estimates for your online shopper, saves you and your customer money and it ensures fast delivery of their purchase. According to Shipwire, the XML Shipping Rates allow any e-commerce application to integrate real-time shipping rates into their checkout process. This means instant quotes automatically from the warehouse closest to each customer!

Shipwire XML Shipping Rates

Shipwire XML Real-Time Inventory

Shipwire XML Tracking Status


Shipwire Shipping Rates API Reference Site & Customer Comments

www.happytiffin.com
The Shipwire XML module developed and supported by Shopping Cart Software Solutions is outstanding! I can now reliably offer shipping quotes straight from the Shipwire system and have accurate charges reflected to the customer. It works seamlessly with my CREloaded B2B cart. Shopping Cart Software Solutions was very helpful and able to integrate and remedy any functionality or design issues within hours. I would not hesitate to recommend this module to anyone looking for a quick and ready solution to your shipping problems as Shopping Cart Software Solutions offers continued support and stands behind their development work.
– Andrea, Happy Tiffin, www.happytiffin.com

Update Inventory with Supplier’s CSV, Tab, XML Inventory Feed (Zen Cart, Oscommerce, Cre Loaded)

When your supplier provides XML, CSV or tab delimited data feeds of their inventories, the best thing to do is to implement an automated system that can take this feed and use it to update  your store pricing and stock levels. For a small store this can be done manually via Easy Populate easily. However for a mid-size ( up to 500 product) to large store (more than 10,000 products), using Easy Populate to manually load products becomes tedious.

I have develop a system which can handle single or multiple data feeds in any file format to load products into stores from classic oscommerce,  to zen cart, to cre loaded, etc. This a real time inventory feed. The system is easy to use, can be configured to include products attribute option, attribute option values, download product images, and does not need any manual intervention. It effectively gives a store owner the ability to focus exclusive on running the business rather than chasing inventory because of constant update.

This system works with virtual any supplier inventory feed for including Petra, Synnex, Doba, dbldistributing, trademarkcommerce, CNET, Effex Media, Murphysmagic, ATS Distribution, Pixmania, Fragrance Net etc. Contact me today for references and a free consultation on how to implement on your store.

Inventory Update Script
Method and System for Loading Large Amount of Product Attributes without using Easy Populate

Reference Sites
automated inventory load & update cre loaded: www.collegegiftregistry.com
automated inventory load & update cre loaded: www.strutmanelectronics.com
automated inventory load & update cre loaded: www.promgowns4less.com

automated inventory load & update zen cart: www.mscom2000.com
automated inventory load & update zen cart: www.shopthe7.com/pokershop/

& in url instead of & with Ultimate SEO URLs

&amp in URL
If you have Ultimate SEO URLs installed and you are having & in url query string, go to your admin configuration. Under SEO URLS configuration, change “Output W3C valid URLs (parameter stirngs)” to false as shown in the left image.

Shipwire XML Warehouse Real-Time Inventory

This is a follow up to an earlier blog on Shipwire Order Status Tracking. From time to time there will be need to synchronize inventory on shipwire system with the inventory on your web site. shipwire real-time inventory integration script accomplish this objective. The script can be set up as a cron/schedule job or it can be run at any time on as needed basis.

shipwire-real-time-inventory-integration

shipwire developer/affiliate link