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.

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

 

 

 

 

Among other things, if you are getting this error, make sure to add “user” to your “database” through your cpanel. It is very easy to forget this steps, espeially if you are going through this configuration for the first time.

Select your choice of user and database then click the Add button to process your selections.

Next you will see the privilege selection screen. Selection your options or select ALL.

For an average e-commerce site, managing product quantity prices for different customer groups can be a daunting task. If you look at it closely, for 10 different prices and three different customer groups, that translate to 30 different values to update. Now multiply that by 200 different products, that is 6000 different values to update.  Even with the aid of easy populate, it does not in any way reduce the volume of work that needs to be done.

In the spirit of continuous improvement, there is a solution that eliminates this problem. What the solution does is provide the capability to set the base price and end price for each product. By using a linear relationship, the individual prices for each price points can be calculated on the fly there by eliminating manual intervention.

Another advantage of this method is the ability to use it with easy populate effectively. There is no need to replicate rows to accommodate the different customer groups.

It takes a lot of efforts to get inventory updated accurately for any store. For online stores getting product feeds from one or more supplier this is even more important and complicated since inventory quantity change from time to time. Also there may be situation where the number of products make it impratically to manually go through each products one by one to select what to sell online.

This is where Inventory Update Script comes to play. It can be set up to automatically select products based on pre-defined criteria and to load these products at pre-defined time of the day without having to manually do anything. Also images can be automatically downloaded and filtered so that decisions can be made efficiently regarding products without images. This allows store owners to focus specifically on running the business instead of struggling with loading products.

Write today for a demonstration.