search

Frank-Shanghai / PencilCase

0 stars 0 forks source link

Feature - Import Product #13

Closed Frank-Shanghai closed 6 years ago

Frank-Shanghai commented 6 years ago

Import Product. Select product from combobox. Input import wholesale price. By default, it displays the last time import whole sale price. Input quantity.

Save to update product table in DB.

  1. Calculate new wholesale cost and retail cost based on new import price and quantity, existed inventory and cost. New Retail Cost: (inventory importRetailPrice + newImportedWholesalePrice quantity)/(inventory + quantity times) New Wholesale Cost: new retail cost product.Times

  2. Update import wholesale and retail price with new data.

  3. Update product inventory.

  4. Insert new order, update product in inserting new order success call back.

[Updating History] [5/22/2018] Update descriptions after finishing this PBI

Frank-Shanghai commented 6 years ago

Disable the ability for user to edit the inventory field in Product Editor.

Need to create Orders table, this table should include import orders, retail orders and wholesale orders, 3 different types of orders.