This is a follow up to an eralier 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

Shipwire Order Status Tracking. Shipwire is a service that lets you focus on growing your business by removing the hassle of shipping and storage. You can read more about the service at how shipwire works.

In case you already have shipwire service, when shipwire ships an order, the order status can automatically be updated to Shipped on your site. That way you don’t have to manually go through every order to figure out which has been shipped and which has not. Also an order tracking link for each of the carriers (Fedex, UPS and USPS) is provided through the admin customer order interface.

Shipwire Order Status Tracking

Shipwire developer/affiliate link

Call for Price Control

This modification is for displaying customer friendly sales message for products in selected category.  Messages like “Call (123) 456-7890 for Price”, “Negotiable Pricing”, etc. can be entered into an input text box.

This Modification is integrated into the edit category page (in admin) where you can  turn Call for Price feature on or off with the aid of two radio buttons. When Call for Price is on for a product category, an input text box is provided for entering texts to be displayed on the store front.

There are instances where product listing for a category needs to be different from product listing of another category. This feature can be

category product listing control

 enabled by customizing the category edit page. The customization includes two radio buttons and some changes to the categories_description table.

When a returning customer logs in, selected product attributes works fine. However when a customer uses the purchase without account (pwa) option, selected product attributes does not display either on the product confirmation page or on the order detail in the backend (admin) if the order is placed.

This is a difficult bug to track down; it took sometime to conclude that restore_contents() is the problem.

restore_contents() function is located in the shopping cart class.

To fix, go to catalog/includes/classes/shopping_cart.php

Look for function restore_contents() {

Then look for global $customer_id, $gv_id, $REMOTE_ADDR;

Add $languages_id to this line like so

global $customer_id, $gv_id, $REMOTE_ADDR, $languages_id;

or

global $customer_id, $gv_id, $languages_id, $REMOTE_ADDR;

For many e-commerce store owners using CRE Loaded SEO URL module, the challenge has been how to effectively utilize CRE Loaded SEO URL module with product search engine and xml sitemap feeds like Google Product Search and Google XML Sitemap feeds . I have been able to get CRE Loaded SEO URL module to work with both (Google Product Search and Google XML Sitemap feeds); the same method can be used to generate feeds for Yahoo, MSN, Edgeio(Google), Mysimon and other product search engine and xml sitemaps.

By default shipping rate quote are displayed from highest to lowest. In case you find it useful fo your potential customer to see the lowest shipping rate first, it is necessary to reverse the shipping rate qoute order.

To implement this process for ups shipping module, open your ups shipping module located in /include/module/shipping

Look for $upsQuote = $this->_upsGetQuote(); right below it add $upsQuote = array_reverse($upsQuote);

After the change you should have:

$upsQuote = $this->_upsGetQuote();

$upsQuote = array_reverse($upsQuote);

For tutorial on how to use Easy Populate Wizard, read Easy Populate Wizard Tutorial

Please post your EP (Easy Populate) Wizard  

• feature requests,
• commet, and 
• feedback here. 

 Thank you.

STEP - 1 SELECT EP type corresponding to the one you use for your store.

EPA - Easy Populate Advanced comes with cre loaded. Product identification based on product id.

EPB - Easy Populate Basic - http://www.oscommerce.com/community/contributions,500. Product identification based on product model. A variant of this comes with cre loaded as well.

Easy Populate Wizard Step 1

STEP - 2  Here you provide information about source file

  1. Field Delimiter 

    possible selections in this drop down are asterisks(*), caret(^), comma(,), dash(-), pipe(|), semi colon(;), space(\s), tab(\t), tilde(~). Default is tab(\t)

  2. Source File Name

    Use the “select” button to bring out file dialog window

  3. First Row Contains Column Headings

      Check this checkbox if the first row of the data/source file contains column headings

  4. Reference Column

    Use this to select the column you will like to fix and use as reference for navigational purposes.

easy populate wizard step 2a

Easy Populate Wizard Step 2b

 

STEP 3 Here you provide information about destination file that is the you want to save your processed data as.

1. Field Delimeter drop down for selecting the type of delimiter to use. The default and recommended delimiter is the tab (\t). Possible values as asterisks(*), caret(^), comma(,), dash(-), pipe(|), semi colon(;), space(\s), tab(\t), tilde(~).

2. EPA or EPB File Name to use.    

Easy Populate Wizard Step 3a

Easy Populate Wizard Step 3b

STEP 4 This is the final step. Here you are provided with EPA or EPB dedpending on your selection in step 1.

3. When you do not need a field, select exclude this field. 

 

Easy Populate Wizard Step 4a

Easy Populate Wizard Step 4b

 

 

 

 

I have just installed Time Zone Offset contribution. Installation instruction is clear except I couldn’t immediately find the correct putenv timezone argument for my location. To locate my timezone I find these two links very useful.
List of Supported Timezones
Standard time zones of the world as of June 2008

timezone

 Changes recommended in this thread Time Zone Offset - Adjust to match your location, Needs a little work to be complete.. is not necessary.