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.
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 Real-Time Inventory
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
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/
Following the clue from here, I put the attribute option back in 6.2 patch 10. Same method works on newer version.
Please note that line numbers are approximate.
1. Export
Applies to admin/easypopulate_export.php
1.1 Uncomment attribute option drop down in line 846
1.2 Around line 370 change
$attribute_options_query = "select distinct products_options_id from " . TABLE_PRODUCTS_OPTIONS . " where products_options_name = '" . $value . "'";
to
$attribute_options_query="select distinct po.products_options_id from products_options po, products_options_text pot where pot.products_options_name= '".$value."' and po.products_options_id=pot.products_options_text_id"; $attribute_options_query="select distinct po.products_options_id from products_options po, products_options_text pot where pot.products_options_name= '".$value."' and po.products_options_id=pot.products_options_text_id";
1.3 Make exactly the same change to around line 385
1.4 Around line 643
change
$attribute_options_languages_query = "select products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . (int)$attribute_options['products_options_id'] . "' and language_id = '" . (int)$lid . "'";
to
$attribute_options_languages_query = "select products_options_name from " . TABLE_PRODUCTS_OPTIONS_TEXT . " where products_options_text_id = '" . (int)$attribute_options['products_options_id'] . "' and language_id = '" . (int)$lid . "'";
2. Import
Applies to admin/easypopulate_import.php
2.1 Around line 1182, change
$attribute_options_query = "select products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . (int)$$v_attribute_options_id_var . "'";
to
$attribute_options_query = "select products_options_name from " . TABLE_PRODUCTS_OPTIONS_TEXT . " where products_options_text_id = '" . (int)$$v_attribute_options_id_var . "'";
2.2 Around line 1196, change
$attribute_options_insert_query = "insert into " . TABLE_PRODUCTS_OPTIONS . " (products_options_id, language_id, products_options_name) values ('" . (int)$$v_attribute_options_id_var . "', '" . (int)$lid . "', '" . $$v_attribute_options_name_var . "')";
to
$attribute_options_insert_query = "insert into " . TABLE_PRODUCTS_OPTIONS_TEXT . " (products_options_text_id, language_id, products_options_name) values ('" . (int)$$v_attribute_options_id_var . "', '" . (int)$lid . "', '" . $$v_attribute_options_name_var . "')";
2.3 Around line 1208, change
$attribute_options_update_lang_query = "select products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . (int)$$v_attribute_options_id_var . "' and language_id ='" . (int)$lid . "'";
to
$attribute_options_update_lang_query = "select products_options_name from " . TABLE_PRODUCTS_OPTIONS_TEXT . " where products_options_text_id = '" . (int)$$v_attribute_options_id_var . "' and language_id ='" . (int)$lid . "'";
2.4 Around line 1214, change
$attribute_options_lang_insert_query = "insert into " . TABLE_PRODUCTS_OPTIONS . " (products_options_id, language_id, products_options_name) values ('" . (int)$$v_attribute_options_id_var . "', '" . (int)$lid . "', '" . $$v_attribute_options_name_var . "')";
to
$attribute_options_lang_insert_query = "select products_options_name from " . TABLE_PRODUCTS_OPTIONS_TEXT . " where products_options_text_id = '" . (int)$$v_attribute_options_id_var . "' and language_id ='" . (int)$lid . "'";
2.5 Around line 1218, change
$attribute_options_update_query = "update " . TABLE_PRODUCTS_OPTIONS . " set products_options_name = '" . $$v_attribute_options_name_var . "' where products_options_id ='" . (int)$$v_attribute_options_id_var . "' and language_id = '" . (int)$lid . "'";
to
$attribute_options_update_query = "update " . TABLE_PRODUCTS_OPTIONS_TEXT . " set products_options_name = '" . $$v_attribute_options_name_var . "' where products_options_text_id ='" . (int)$$v_attribute_options_id_var . "' and language_id = '" . (int)$lid . "'";
3.0 epconfigure
3.1 set $products_with_attributes = true;
3.2 $attribute_options_select = array(‘Size’, ‘Model’); // uncomment and fill with product options name you wish to download use $attribute_options_select = ”; if you wish to download all product options
Please BACK UP your files before any change…
Recent Comments