Citrus Retail Development Blog

Support for Ebay Item Specifics

We’ve added support for item specifics to our Ebay module. Once a product has been added to an Ebay category the ability to setup item specifics will be available in the Management Interface.

 

Define an Ebay Category:

We can now set item specifics on the product:

 

Find Inactive Items Quick and Easy

We’ve added a custom report to CitrusStore which helps identify inventory on-hand, which is NOT active online for purchase. It allows you to browse local inventory, also SIM and other RMS/warehouses. Therefore really useful for inputting new products on your site. To find it on the latest version of Merchant tools, just look for the ‘Find Inactive Products’ tab under the Product Management category on the navigation bar:

This opens up a page report showing the inactive items, which you can click on to jump to the product page on your Merchant Tools:

Enhancing RMS with Extra Reports

In this Blog post we wanted to make you aware of the growing list of reports Citrus Lime provide to enhance RMS. Below are 7 you can find ready and waiting in RMS. Reports which we have found really useful and believe you will too, here is how to find them:

The reports are located in two places within RMS Manager, SIM reports and extra memorised RMS reports.

 

Firstly, the SIM reports

If you go to Utilities on the RMS Manager toolbar and then select RMS Reports from the drop down menu you will open a window showing three tabs to the currently available SIM reports.

Each of these tabs open a report as described below:

Citrus Lime RMS reports – sales

This report shows sales by department. The start and end dates of the sale period for the report can be altered to your needs via the refresh on the top line. Each department can be expanded to show the sales for given dates within the time period and then again down to individual items.

This report is a really clear tool to allow you to see what is selling and when.

Citrus Lime RMS reports – tender

This report shows the tender values over the time period of the report. This can again be set to a start and end date of your choice. Each closing date can then further be expanded to show individual registers and individual batches on each register.

A really useful report for getting a visual of sales for each day across your store.

 

Citrus Lime RMS reports – VAT Analysis

This report shows sales per day broken down to excluding tax and tax due. Again, this can be further expanded by register and batch, and then also by VAT type.

A report designed to give clear assistance looking at VAT for your store.

 

 

Secondly, Memorized reports – SIM reports

These Reports have proved themselves to be truly useful and we wanted to share them. They have been memorised on the RMS report menu. They use the data provided by SIM and show it in handy ways. If you go to Reports on the RMS manager toolbar and then select Memorized from the drop down menu, you will open a list of memorised report. Scroll down this list and you will find four which begin with the prefix, SIM:

 

SIM – Aging Item List

This report will show you all the items you currently have in stock, but have not sold since a given date. Just change the dates in the report filter to suit those you need, for example you may use a ‘to’ date of 8 weeks ago.

This report is very useful for giving you a clear idea of what stock is gathering dust and maybe inefficient capital in your business – perhaps a start of a promotional sales list. The report could also be used to carry out a process of identifying items which are not selling and then beginning to work out why. These listing items can be investigated to see if their listing is correct on your site, or incorrectly entered on RMS, maybe marked as inactive or perhaps it may be the sale price has become uncompetitive.

SIM – Cyclescheme Voucher Usage Report

This report gives a list for the usage of Cyclescheme vouchers between two given dates. Just use the report filter (as shown in the image) and highlight the date in the filters box. Change the values to the from and to dates you require and click Add. Then select and remove the unwanted original dates and then click OK. You will then have a report to keep track of Cyclescheme voucher through your store.

SIM –Detailed Sales Report (With VAT Detail)

This report gives you an internal RMS Report showing detailed sales information for a fixed time period- including VAT data.

Useful to identify what products are selling, as well as to help with tax returns.

SIM – Items on Backorder at Supplier Report

This report provides a list of items which are on back order at your suppliers. This report is a quick and convenient way to see what items you have on purchase orders. It takes that a step further, allowing you to see which purchase order, whether it has been placed and you can even double click on the purchase order and go straight to the purchase order details.

This report is very useful for staying on top of your purchase orders- all items ordered from all your suppliers in one place. A good place to start chasing those items that have not yet turned up from the suppliers.

Refine by Leaf Category on Brand Landing Pages

We’ve had filtering by brand on our category results pages for some time. When you land on a brand they are leaf categories themselves on our brand landing pages. We’ve written some “magic” to find all the other categories the products on a brand lander appear in. We’ve then filtered this further to ensure we only list leaf categories.

The end result is speedy and efficient* method for your customers to break down the products in each brand you range by the type of product.

* Some serious SQL heavy lifting is required to do this, so we cache the results, only regenerating when the number entries in the ProductCategories table changes. Changing this from adding a stack of page load time, to being faster than a greased rat!

Speed and Logic Improvements to CSS Nav

Many (most) of our ecommerce systems are driven by variants of CSS navigation. We’ve implemented the ability to show the number of products in a category within CSS and this is highly tuned (cached) so CSS remains a fast way of generating navigation.

This can be implemented on any flyout navigation system, and most of our other navigation types. 

Better Search Version 2.0

We’ve made the following improvements to our “Better Search” BETA.

 

Searches Intelligently:

• A search for “Jackets” returns all “Jacket” products.
• Hunts multiple fields, for example “Blue Trainers” would return any “Blue” product in the “Trainers and Shoes” department, even the product does not have these keywords in the description.

Searches more “stuff”:

• Now searches the colour field, so you can search for “Red Jacket”
• New searches the code field allowing users to search for a product code

More Filters:

• Can filter by “sale items”
• Filter by the colour field

Sorting:

• Sort by Name, Name reversed
• Price High and Price Low
• By colour

Configurable:

• Filters can be switched on and off by designers, for example the Coal page has the control locked to the Coal brand. This can easily be used on brand landing pages, and to create filterable sale pages. In the example (found near the bottom of the page) the control is configured to be locked to the Coal brand, so the brand filter is hidden.
  
  

Extreme Performance:

• Fully AJAX with no page postback
• Nice jQuery driven fades to give the user proper feedback for slower searches
• Paging is also AJAX driven

Example Colour Sorting

Coupon Bug Fix

When applying a value (£) discount and applying this “Once Per Order” the discount would only be applied to the first line item on the order.

For example if you have a £10.00 discount, and two different items for £5.00, CitrusStore would only discount £5.00. Whilst this “does what it says on the tin” in the real world this is impractical and has caused confusion.

We’ve amended this logic to apply it across the line items on the order. This is available after build:

 

Bug Fixes and Patches

 

From build :

Build Date : 20 December 2011 // 11:16
Version : 6.6.4368.20800

The following issues have been resolved

1. The setup of custom products now forces the clearing of track inventory rather than relying on the user to set this;
2. We call SetParentCategories every twenty four hours to ensure that parent category selections are always set. Runs nicely Async to avoid performance lockups;
3. Fixed issue with blog engine which allows articles in the blogging system to be renamed.

Better Search

We’ve grafted away and created a greatly enhanced BETA search, this allows the stacking of search terms, allowing a customer to quickly filter products to find the item they are after. You can checkout the prototype here : http://www.workingclassheroes.co.uk/AdvancedSearch.aspx 

Key Features

1. Step by step filtering

2. High performance AJAX partial page refresh

3. Multi word search handling, separating phrases into keywords and multi matching keywords

4. Refine the search as many times as required, with automatic refresh

Step 1 – the user searches for “Jacket”

Step 2 – the user refines by brand

Step 3 – the user refines their search to include colour and only products in the Outerwear Department

Exciting New Fields CitrusStore

Primary Category

We’ve added some new fields in CitrusStore. The first is “Primary Category”, this is the category we will feed Google, and indeed the category we will use on our breadcrumbs control.

You should define this for all products. The drop down shows all leaf categories in your database, setting this ADDS the product to this category as well.

Ranges

We’ve added a field with  a nice dropdown, which allows you to group similar products together. This might be a range of bikes ALA, group of wheels or jackets which comes in different colours: