Order Management Coordinator

Responsibilities

Create orders for Retail, Wholesale Direct, and Marketplaces (Amazon Seller Central, Walmart Seller Center) in ERP.

Use SPS Commerce Fulfillment to update orders via EDI.

Place orders based on the Sell-In Forecast and allocate inventory to customers and sales channels.

Maintain and update master order data, focusing on shortages and their causes.

Create and track warehouse work orders until they are completed.

Provide timely and professional order updates to Retail and Wholesale Direct customers.

Ensure data is accurate in all company and third-party systems and reports.

Ensure that all orders are correctly placed and communicated to both internal and external teams.

Respond to Wholesale Direct customer emails promptly.

Manually enter orders into the ERP system when necessary.

Contact Supply Planning for approval of orders over 50% of the monthly forecast.

Work with Freight to get quotes for domestic and international prepaid LTL shipments.

Ensure prepayment funds are received from customers without Net Terms before releasing orders.

Confirm order release with customers and provide pickup instructions if needed (for CPU orders).

For small parcel orders, send tracking numbers and expected delivery dates to customers.

Gather key data from different sources and create reports to support decision-making.

Use Excel functions (like v-lookup and pivot tables) to organize and analyze data for reports.

Design tables, charts, and graphs in Excel, then add them to PowerPoint presentations.

Keep track of and update files for regular KPI reporting.

Handle orders from online marketplaces and ensure they are processed correctly.

Monitor and manage the movement of inventory between locations.

Keep track of inventory levels and ensure data is accurate.

Create reports on warehouse operations and stock allocation.

Track inventory to make sure items are used or sold in the right order (FIFO First In, First Out, FEFO First Expired, First Out).

Ensure supplies needed for order fulfillment are properly managed and stocked.

Qualifications and Requirements

Expertise in using Excel for data analysis, including v-lookups, pivot tables, and complex reporting.

Strong ability to assess inventory and order trends, identify potential issues, and propose effective solutions.

Clear and coherent in both written and verbal communication skills for interacting with both internal teams and external customers

High level of accuracy in data entry and reporting

Organized and able to prioritize tasks effectively in a fast-paced environment

Strong problem-solving skills and an ability to handle complex order management issues

Responsibilities

Create orders for Retail, Wholesale Direct, and Marketplaces (Amazon Seller Central, Walmart Seller Center) in ERP.

Use SPS Commerce Fulfillment to update orders via EDI.

Place orders based on the Sell-In Forecast and allocate inventory to customers and sales channels.

Maintain and update master order data, focusing on shortages and their causes.

Create and track warehouse work orders until they are completed.

Provide timely and professional order updates to Retail and Wholesale Direct customers.

Ensure data is accurate in all company and third-party systems and reports.

Ensure that all orders are correctly placed and communicated to both internal and external teams.

Respond to Wholesale Direct customer emails promptly.

Manually enter orders into the ERP system when necessary.

Contact Supply Planning for approval of orders over 50% of the monthly forecast.

Work with Freight to get quotes for domestic and international prepaid LTL shipments.

Ensure prepayment funds are received from customers without Net Terms before releasing orders.

Confirm order release with customers and provide pickup instructions if needed (for CPU orders).

For small parcel orders, send tracking numbers and expected delivery dates to customers.

Gather key data from different sources and create reports to support decision-making.

Use Excel functions (like v-lookup and pivot tables) to organize and analyze data for reports.

Design tables, charts, and graphs in Excel, then add them to PowerPoint presentations.

Keep track of and update files for regular KPI reporting.

Handle orders from online marketplaces and ensure they are processed correctly.

Monitor and manage the movement of inventory between locations.

Keep track of inventory levels and ensure data is accurate.

Create reports on warehouse operations and stock allocation.

Track inventory to make sure items are used or sold in the right order (FIFO First In, First Out, FEFO First Expired, First Out).

Ensure supplies needed for order fulfillment are properly managed and stocked.

Qualifications and Requirements

Expertise in using Excel for data analysis, including v-lookups, pivot tables, and complex reporting.

Strong ability to assess inventory and order trends, identify potential issues, and propose effective solutions.

Clear and coherent in both written and verbal communication skills for interacting with both internal teams and external customers

High level of accuracy in data entry and reporting

Organized and able to prioritize tasks effectively in a fast-paced environment

Strong problem-solving skills and an ability to handle complex order management issues