Introduction
RetailSql has been designed to cover all aspects of merchandising in the retail fashion industry including:
purchasing, sales, costing, importing, markdowns, fill-ins, and store management for shoes, apparel, and
accessories for men, women, and children.
RetailSql is designed for the special needs of fashion retailing. Variable size ranges, prepacked and loose size
cartons, product categories and classes, styles and colours, and brands.
RetailSql has been designed by a multi store retailer to follow the work practices of the retailer, it works the
way you do. This makes the system easy to learn and reduces the amount of work required to train and operate
the system.
Purchasing
The system works as you do so we start with buying, details of the buy are entered through the purchase order
system. New stock lines are created at the time of order placement. Stock can be purchased according to
predefined standard size ranges or in standard manufacturer packs. The Open To Buy (OTB) tool plus
reporting on gross commitments, net commitments, and cost schedules by category, class, vendor, and
delivery location keeps you fully informed, assisting both stock and cash flow. Deliveries can be received at a
central warehouse or at each store. Fast selling stock can be reordered using the repeat order system.
Stock Management
Goods received are integrated into a distribution system that produces barcode labels and individual transfer
lists for each shop. Reports from the sales recording system ensure the efficient distribution of units to shops
where the stock is being sold the best. Picking lists replace items sold in store fiom back stock to maintain the
stock levels in each store. The sales analysis system may also be used for redistribution of stock to stores
where it is a better seller, keeping the stock in the right place at the right time. Markdown management and
promotional pricing is used to alter the stock prices and notify the stores. Used correctly in conjunction with
the sales analysis reports and stock movements, this system can help sell more stock at a higher profit.
Sales Recording and Analysis
The daily sales recording and processing is fully automated Sales values are recorded for turnover and gross
contribution analysis. Staff performance and timesheets assist with staff management. A comprehensive set of
sales analysis reports covers both units and dollar values. RetailSql has in depth analysis of the performance
of each stock line by size, colour, location and staff. Best seller lists by dollars and units, can be integrated
with product photos, to give the buyer the best visual of trends for that category. Summary reports give
overviews of performance by vendor, season, style, shop, dategory, and staff. The overall view keeps you
informed of trends and directions and highlights areas in need of attention, then you can dive into the detail.
Indicators
The key numbers that tell you how your business is performing. Every day RetailSql reports the three
essential measures of your business: Gross turnover, gross contribution %, and weeks on hand Monitoring
and controlling these numbers is essential for long term success.
Integration
RetailSql and COMPTIL are seamlessly integrated with fully automated communications and processing.
RetailSql is able to prepare data for import into MYOB.
Internet
Run your business from anywhere. RetailSql uses SQL and web technology so you can securely run your
business over the Intemet. RetailSql also interfaces with www.shoenet.com.au for vendor information, reports
and refill.
Reliable
RetailSql is THE merchandising system to use when you want the facts. Don't just rely on “gut feelings” and
staff “impressions”. RetailSql gives you the information you need. What’s selling where. What’s not selling.
Which shops are performing or not performing. Staff performance. Overstocking and understocking. Late
deliveries. Purchase commitments.

Key Features