Đã Đóng

[PRESTASHOP] Inventory Purchasing Module

I have a custom module which assists with creating inventory purchase orders.

- Takes past 30 days sales to get daily sales average for each product (by SKU, not product ID)

- Takes account of "combination" products where 'Product A' is really a combination of 'Product B' and 'Product C' we disregard product A and count those sales towards both B's and C's sales for finding our purchasing need.

- We assume a 30 day turnaround time, and anything under 60 days of stock needs reordering, under 45 days needs urgent reordering.

- Reorder quantity is calculated as ((daily sales average)*(60))/(current stock qty)

The module is now proving to be too simple for our needs. We need several modifications made:

We can't rely on just one set of sales figures for deciding a purchase ammount. se calculations are now proving to be insufficient since a number of things, such as running out of stock for weeks, can create misleading figures. Thus we need to look at multiple figures:

0-15 days

16-30 days

30-60 days

60-90 days

0-15 days

0-30 days

0-60 days

0-90 days

With those figures, we can then either use the highest number from the set, or account for growth rate if the numbers show consistent growth.

We also need to be able to enter in pending ammounts for those calculations. As in, if we have 50 pieces in stock and just placed an order for 25 more, we need to be able to account for those 25 pending items. This way we can keep track if our needs change during that 30 day turnaround waiting for inventory. Likewise, we need to be able to clear out those pending numbers when inventory arrives.

Kỹ năng: MySQL, PHP, Prestashop

Xem thêm: prestashop inventory, prestashop inventory module, prestashop purchasing, sku inventory, product inventory, prestashop products, custom orders prestashop, show sku prestashop, prestashop create account, count products prestashop, count products number prestashop, inventory module, reorder rate, inventory daily, track inventory daily, daily inventory, products count prestashop, prestashop orders, prestashop time, product count prestashop, prestashop custom order, sku number, prestashop module inventory, count inventory, inventory products

Về Bên Thuê:
( 0 nhận xét ) Farmington, United States

Mã Dự Án: #1681640

4 freelancer đang chào giá trung bình $313 cho công việc này

SunFlowerBiz

Hi, please check PM for our portfolio. Regards,

$350 USD trong 7 ngày
(66 Đánh Giá)
7.0
epark

================prestashop expert.please check pm=====================

$350 USD trong 7 ngày
(113 Đánh Giá)
6.7
harmindersingh26

Dear Sir/Madam, This letter is to express my interest in discussing your requirement posted on oDesk. The requirement posted by you is a strong match for my well-rounded background. We have worked on several project Thêm

$300 USD trong 7 ngày
(0 Đánh Giá)
0.0
WI6v1QTl9

Custom Software Development - <b><i>Removed by Admin</i></b>

$250 USD trong 1 ngày
(0 Đánh Giá)
0.0