Sales & Operations Administrator

Confidential; Denton; On-site; GBP 26,000 - 32,000; Full time

Job summary

Confidential is seeking an experienced Sales & Operations Administrator to support wholesale customers, contract orders, concessions, retail and warehouse administration. You will manage sales data, stock, invoicing and reporting using Excel and SAGE, with exposure to Shopify, FedEx and Royal Mail systems.

The role demands accuracy, initiative and the ability to work across several spreadsheets and workflows.

Qualifications

• Excellent Microsoft Excel skills are essential.
• Ability to work independently with multiple spreadsheets and reports.
• Experience with SAGE and logistics/ ecommerce tools is advantageous.

Responsibilities

• Handle wholesale and customer administration, orders and invoicing.
• Input sales data and production of packing lists, reports and labels.
• Coordinate UK and international freight and deliveries and assist with credit control.
• Produce profit and margin calculations for forward orders and maintain records.

Skills

Excel proficiency

Data analysis

Formulas & calculations

Margin calculations

Sorting & filtering

Multi-worksheet workbooks

Reporting

Attention to detail

Independent working

Tools

SAGE

Outlook

Word

Shopify

FedEx

Royal Mail

Job description

The Role

We are recruiting for an experienced Sales & Operations Administrator to join a busy and established business.

This is a varied position supporting several areas of the operation, including wholesale customers, contract orders, concessions, retail and warehouse administration.

The role involves working with a significant amount of sales, stock and order data, therefore strong Microsoft Excel skills are essential.

This is not a basic data-entry position. The successful candidate must be comfortable working independently with multiple spreadsheets, reports, calculations and workbooks and be able to pick up existing systems quickly.

Key Duties

Wholesale & Customer Administration

• Answering telephone and email customer enquiries
• Processing customer orders accurately
• Raising invoices using SAGE
• Inputting website and shop sales onto SAGE
• Producing packing lists and associated paperwork
• Managing back orders and monitoring outstanding stock
• Updating customers regarding expected order and delivery dates
• Arranging UK and international freight and deliveries
• Producing FedEx shipping labels
• Assisting with credit control and chasing overdue invoices
• Producing sales and agent reports

Contract & Order Administration

• Producing order forms for the warehouse from customer contracts
• Preparing relevant warehouse and dispatch documentation
• Maintaining forward-order Excel workbooks
• Producing profit and margin calculations for forward orders
• Following individual customer booking-in procedures
• Preparing shipment and incoming stock documentation
• Maintaining accurate records of outstanding and future orders

Concession Administration

• Processing weekly and monthly concession sales information
• Creating barcodes and RRP labels
• Producing packing lists and replenishment sheets
• Booking deliveries and preparing ASN documentation
• Producing seasonal sales information
• Monitoring and organising previous-season returns
• Liaising with concessions regarding seasonal changeovers
• Arranging collections and deliveries

Retail & E-Commerce

• Processing and printing Shopify orders
• Producing Royal Mail and FedEx shipping labels
• Responding to online customer service enquiries
• Processing returns and exchanges
• Maintaining retail pricing documentation
• Producing monthly internet revenue and returns reports
• Providing cover for online order processing when required

General Administration

• Maintaining warehouse logs
• Producing daily out-of-stock reports
• Creating warehouse, stock and product labels
• Updating stock sheets
• Producing customer profit/loss information
• Preparing agent stock, commission and order reports
• Monitoring weekly FedEx costs
• Assisting with brochure mailings
• General administrative support across the office and warehouse operation

Skills & Experience Required

Excellent Microsoft Excel skills are essential.

Candidates must be confident using Excel independently and should be comfortable with:

• Formulas and calculations
• Percentages and margin calculations
• Sorting and filtering
• Working across multiple worksheets and workbooks
• Maintaining existing spreadsheets
• Producing and updating reports
• Manipulating sales, stock and order data
• Checking figures and identifying errors
• Working accurately with large amounts of information

Previous experience using SAGE would be highly desirable.

Experience with Outlook, Word, Shopify, FedEx, Royal Mail or similar systems would also be advantageous.

Please note

This role requires someone with genuinely strong Excel ability who can hit the ground running. Basic Excel knowledge will not be sufficient.