Shopping Cart Software Solutions

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

admin — Sat, 31 Oct 2009 20:12:02 +0000

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

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

admin — Wed, 28 Oct 2009 03:16:13 +0000

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

admin — Fri, 03 Jul 2009 01:12:10 +0000

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.

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

admin — Sun, 31 May 2009 00:49:45 +0000

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)

admin — Wed, 18 Mar 2009 23:29:25 +0000

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

admin — Fri, 13 Mar 2009 01:46:44 +0000

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

admin — Sat, 28 Feb 2009 21:09:41 +0000

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, 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

admin — Wed, 11 Feb 2009 22:30:56 +0000

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.

Learn Easy Populate in a Weekend

admin — Tue, 06 Jan 2009 18:55:51 +0000

Easy Populate AdvancedUnderstanding Easy Populate AdvancedEasy Populate Advanced is a product content management system for adding, editing, and deleting existing products. It is a robust php script capable of handling many modifications to suit any oscommerce based shopping cart needs. It can be set-up to run as cron/schedule job, modified to take input from database instead of a text file, it can be modified to include product extra fields from the product table or from another tables; the list goes on and on. In fact it is the specific needs of an e-commerce site and capability shop owner/programmer that determines or limit what Easy Populate script can do.
* Easy Populate Advanced file name must have EPA prefix. Examples of  proper file names are EPAxyz.txt, EPAXYY.txt and EPA_xyz.txt.
* Every row must end with EOROER and there must not be any other text or character after EOREOR column on each row.
* Product model (v_products_model) string length/number of characters must be less than or equal to 25. This is the predefine value in epconfigure.php ($modelsize = 25). If you need to have more than 25 characters change this value to say 50 ($modelsize = 50). Then you can either access you database directly and run ALTER TABLE `products` CHANGE `products_model` `products_model` VARCHAR( 50 ) or add this line to your easypopulate_import.php below include statements at the top; tep_db_query(“ALTER TABLE `products` CHANGE `products_model` `products_model` VARCHAR( 60 )”).
* The default file delimiter is tab.
* Header fields with the name of each column your want to import must be the first row that is v_products_id, v_products_model, …, v_status, v_action, EOREOR
* Unwanted columns can be deleted. For example v_products_image_sm_1, v_products_image_xl_1, v_products_url_1, v_date_avail, v_date_added can be deleted if they are not needed.
* v_status field for setting active and inactive products
* File split
* The default no of categories is 4 (v_categories_name_1, … ,v_categories_name_4), to have more categories, increase $max_categories from 4 to say 7 in epconfigure.php. Then add more columns to your EPA file to reflect the change. In case the $max_categories is now 7 then the EPA files should have (v_categories_name_1, v_categories_name_2, … ,v_categories_name_6, v_categories_name_7).
* The temp folder within the main install must be writteble. You can use a folder other than the temp folder ut your have to specifiy the name of your new folder in the configuration file.
* Multi language support.
Using Easy Populate Advanced to add productTo add new product value of the v_products_id must be 0; this is a required field, do not leave it blank or empty. In case you are sure you have unique product id, you can use your predefined product id. 
Using Easy Populate Advanced to delete productUse v_action column to delete products. Each row must have delete (all lower case)
Using Easy Populate Advanced to edit productUsing Easy Populate Advanced to manage product attributtesUsing Easy Populate Advanced with extra fields in product tableUsing Easy Populate Advanced with extra fields in another table

Easy Populate BasicUnderstanding Easy Populate BasicUsing Easy Populate Basic to add productTo add new product value of the v_products_model must be supplied and it must be unique; this is a required field, do not leave it blank or empty.
Using Easy Populate Basic to delete productUsing Easy Populate Basic to edit productUsing Easy Populate Basic to manage product attributtesUsing Easy Populate Basic with extra fields in product tableUsing Easy Populate Basic with extra fields in another table

Shipwire XML Warehouse Real-Time Inventory

admin — Sat, 03 Jan 2009 16:42:20 +0000

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