Fermé

[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.

Compétences : MySQL, PHP, Prestashop

Voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Farmington, United States

N° du projet : #1681640

4 freelance ont fait une offre moyenne de 313 $ pour ce travail

SunFlowerBiz

Hi, please check PM for our portfolio. Regards,

350 $ USD en 7 jours
(66 Commentaires)
7.0
epark

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

350 $ USD en 7 jours
(113 Commentaires)
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 Plus

300 $ USD en 7 jours
(0 Commentaires)
0.0
WI6v1QTl9

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

250 $ USD en 1 jour
(0 Commentaires)
0.0