CN108133346A - The method and system that the setting of bom inventories uploading system is sold by group - Google Patents
The method and system that the setting of bom inventories uploading system is sold by group Download PDFInfo
- Publication number
- CN108133346A CN108133346A CN201711471929.2A CN201711471929A CN108133346A CN 108133346 A CN108133346 A CN 108133346A CN 201711471929 A CN201711471929 A CN 201711471929A CN 108133346 A CN108133346 A CN 108133346A
- Authority
- CN
- China
- Prior art keywords
- commodity
- group
- inventory
- price
- trade name
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
Abstract
A kind of bom inventories uploading system setting is included the following steps by the method for group sale:S1, merchandise news in inventory is obtained from supplier's upload inventory;S2, background system examine inventory, pass through for closing rule commodity;It reports an error for not conforming to rule commodity prompting;S3, supplier backstage receive the handling result of return, and upper successor changes inventory content, uploaded again after setting group quantity according to the miscue of return;S4, background system detection inventory;The group quantity G values of each row of data are detected, work as G>=2, system automatic conversion trade name N, commodity weight W, commodity stocks S, commodity price P values;S5, background system detect after, carry out commodity restocking sale.
Description
Technical field
The present invention relates to merchandise news technical field, more particularly to a kind of bom inventories uploading system setting is by group sale
Method and system.
Background technology
(data up to ten thousand) can use BOM (Bill of Material) when supplier's upload commodity are more in the prior art
Method for uploading, containing each marque, quantity, unit price, essential information etc. in inventory.
The defects of main, has:
1 commodity having are disk, winding belt package, and partition is complicated
2 commodity restockings sale needs RMB price to be converted into a dollar price, and certain cargo prices can be less than 0.01 yuan,
Unit price can be less than 0.01 after being converted to dollar, and minimum of overseas payment platform supports the price of two number decimals, so as to cause quotient
Product can not be sold.
Invention content
In view of this, the present invention proposes a kind of method and system of bom inventories uploading system setting by group sale.
A kind of bom inventories uploading system setting is included the following steps by the method for group sale:
S1, merchandise news in inventory is obtained from supplier's upload inventory;
S2, background system examine inventory, pass through for closing rule commodity;It reports an error for not conforming to rule commodity prompting;
S3, supplier backstage receive the handling result of return, and upper successor is changed according to the miscue of return in inventory
Hold, uploaded again after setting group quantity;
S4, background system detection inventory;The group quantity G values of each row of data are detected, work as G>=2, system automatic conversion
Trade name N, commodity weight W, commodity stocks S, commodity price P values;
S5, background system detect after, carry out commodity restocking sale.
In method of the bom inventories uploading system of the present invention setting by group sale,
The step S1 merchandise newss include trade name, brand, encapsulation, lot number, brief introduction, commodity weight, commodity library
It deposits, commodity price, commodity remarks, minimum lot-size, organize incremental data.
In method of the bom inventories uploading system of the present invention setting by group sale,
Detection content is in the step S2:
Trade name, commodity weight, commodity stocks, commodity price are that must fill out,
Commodity weight, commodity stocks, commodity price are number;
Trade name, brand, encapsulation, lot number, brief introduction are English or number;
Price only retains two-decimal, it is impossible to less than 0.2 yuan;
Excel document is converted into database data by background system, and returns to handling result.
In method of the bom inventories uploading system of the present invention setting by group sale,
Conversion formula is in the step S4:
N=n+G+pcs, wherein N are trade name, and n is former trade name, and G is a group quantity, and pcs is unit abbreviation)
W=w x G round up and retain three position decimals, and wherein W is commodity weight, and w is former commodity weight, and G is group number
Amount;
S=s/G, round numbers, wherein downward fetch bit, S are commodity stocks, and s is former commodity stocks, and G is group quantity;
P=p x G round up and retain two-decimal, and wherein P is commodity price, and p is former commodity price, and G is group number
Amount.
The present invention also provides a kind of setting of bom inventories uploading system by the system of group sale, including such as lower unit:
Merchandise news acquiring unit obtains merchandise news in inventory for being uploaded in inventory from supplier;
Inventory verification unit for examining inventory by background system, passes through for closing rule commodity;For not
Rule commodity prompting is closed to report an error;
Inventory setting unit, for receiving the handling result of return, the upper mistake passed on a skill of craft to others according to return on supplier backstage
Prompting is changed inventory content, is uploaded again after setting group quantity;
System detectio unit detects inventory for passing through background system;The group quantity G values of each row of data are detected, work as G
>=2, system automatic conversion trade name N, commodity weight W, commodity stocks S, commodity price P values;
Restocking sales unit after being detected in background system, carries out commodity restocking sale.
In system of the bom inventories uploading system of the present invention setting by group sale,
The merchandise news acquiring unit merchandise news includes trade name, brand, encapsulation, lot number, brief introduction, commodity weight
Amount, commodity stocks, commodity price, commodity remarks, minimum lot-size, group incremental data.
In system of the bom inventories uploading system of the present invention setting by group sale,
Detection content is in the inventory verification unit:
Trade name, commodity weight, commodity stocks, commodity price are that must fill out,
Commodity weight, commodity stocks, commodity price are number;
Trade name, brand, encapsulation, lot number, brief introduction are English or number;
Price only retains two-decimal, it is impossible to less than 0.2 yuan;
Excel document is converted into database data by background system, and returns to handling result.
In system of the bom inventories uploading system of the present invention setting by group sale,
Conversion formula is in the system detectio unit:
N=n+G+pcs, wherein N are trade name, and n is former trade name, and G is a group quantity, and pcs is unit abbreviation)
W=w x G round up and retain three position decimals, and wherein W is commodity weight, and w is former commodity weight, and G is group number
Amount;
S=s/G, round numbers, wherein downward fetch bit, S are commodity stocks, and s is former commodity stocks, and G is group quantity;
P=p x G round up and retain two-decimal, and wherein P is commodity price, and p is former commodity price, and G is group number
Amount.
Implement bom inventories uploading system provided by the invention to set by group method and system of sale compared with prior art
It has the advantages that:
The commodity that unit price is too low in former BOM or packaging is complicated can be converted into one group of commodity restocking sale;Supplier without
Former inventory need to be largely changed, need to only increase a group attribute, the letters such as system meeting adjust automatically trade name, inventory, unit price, weight
Breath.
Description of the drawings
Fig. 1 is the bom inventories uploading system setting of the embodiment of the present invention by a group method flow diagram for sale.
Specific embodiment
As shown in Figure 1, a kind of bom inventories uploading system setting is included the following steps by the method for group sale:
S1, merchandise news in inventory is obtained from supplier's upload inventory;
S2, background system examine inventory, pass through for closing rule commodity;It reports an error for not conforming to rule commodity prompting;
S3, supplier backstage receive the handling result of return, and upper successor is changed according to the miscue of return in inventory
Hold, uploaded again after setting group quantity;After setting group attribute, the SKU cell attributes of the commodity switch to part or disk by piece.Such as G
=500, then the commodity are 1 sale by 500.
S4, background system detection inventory;The group quantity G values of each row of data are detected, work as G>=2, system automatic conversion
Trade name N, commodity weight W, commodity stocks S, commodity price P values;
S5, background system detect after, carry out commodity restocking sale.
In method of the bom inventories uploading system of the present invention setting by group sale,
The step S1 merchandise newss include trade name, brand, encapsulation, lot number, brief introduction, commodity weight, commodity library
It deposits, commodity price, commodity remarks, minimum lot-size, organize incremental data.
In method of the bom inventories uploading system of the present invention setting by group sale,
Detection content is in the step S2:
Trade name, commodity weight, commodity stocks, commodity price are that must fill out,
Commodity weight, commodity stocks, commodity price are number;
Trade name, brand, encapsulation, lot number, brief introduction are English or number;
Price only retains two-decimal, it is impossible to less than 0.2 yuan;
Excel document is converted into database data by background system, and returns to handling result.
Such as:
14th row data verification does not pass through:The form of commodity price is incorrect, P<0.2, a group quantity need to be set.
19th row data verification does not pass through:The form of commodity price is incorrect, P<0.2, a group quantity need to be set.
20th row data verification does not pass through:The form of commodity price is incorrect, P<0.2, a group quantity need to be set.
In method of the bom inventories uploading system of the present invention setting by group sale,
Conversion formula is in the step S4:
N=n+G+pcs, wherein N are trade name, and n is former trade name, and G is a group quantity, and pcs is unit abbreviation)
W=w x G round up and retain three position decimals, and wherein W is commodity weight, and w is former commodity weight, and G is group number
Amount;
S=s/G, round numbers, wherein downward fetch bit, S are commodity stocks, and s is former commodity stocks, and G is group quantity;
P=p x G round up and retain two-decimal, and wherein P is commodity price, and p is former commodity price, and G is group number
Amount.
The present invention also provides a kind of setting of bom inventories uploading system by the system of group sale, including such as lower unit:
Merchandise news acquiring unit obtains merchandise news in inventory for being uploaded in inventory from supplier;
Inventory verification unit for examining inventory by background system, passes through for closing rule commodity;For not
Rule commodity prompting is closed to report an error;
Inventory setting unit, for receiving the handling result of return, the upper mistake passed on a skill of craft to others according to return on supplier backstage
Prompting is changed inventory content, is uploaded again after setting group quantity;
System detectio unit detects inventory for passing through background system;The group quantity G values of each row of data are detected, work as G
>=2, system automatic conversion trade name N, commodity weight W, commodity stocks S, commodity price P values;
Restocking sales unit after being detected in background system, carries out commodity restocking sale.
In system of the bom inventories uploading system of the present invention setting by group sale,
The merchandise news acquiring unit merchandise news includes trade name, brand, encapsulation, lot number, brief introduction, commodity weight
Amount, commodity stocks, commodity price, commodity remarks, minimum lot-size, group incremental data.
In system of the bom inventories uploading system of the present invention setting by group sale,
Detection content is in the inventory verification unit:
Trade name, commodity weight, commodity stocks, commodity price are that must fill out,
Commodity weight, commodity stocks, commodity price are number;
Trade name, brand, encapsulation, lot number, brief introduction are English or number;
Price only retains two-decimal, it is impossible to less than 0.2 yuan;
Excel document is converted into database data by background system, and returns to handling result.
In system of the bom inventories uploading system of the present invention setting by group sale,
Conversion formula is in the system detectio unit:
N=n+G+pcs, wherein N are trade name, and n is former trade name, and G is a group quantity, and pcs is unit abbreviation)
W=w x G round up and retain three position decimals, and wherein W is commodity weight, and w is former commodity weight, and G is group number
Amount;
S=s/G, round numbers, wherein downward fetch bit, S are commodity stocks, and s is former commodity stocks, and G is group quantity;
P=p x G round up and retain two-decimal, and wherein P is commodity price, and p is former commodity price, and G is group number
Amount.
Implement bom inventories uploading system provided by the invention to set by group method and system of sale compared with prior art
It has the advantages that:
The commodity that unit price is too low in former BOM or packaging is complicated can be converted into one group of commodity restocking sale;Supplier without
Former inventory need to be largely changed, need to only increase a group attribute, the letters such as system meeting adjust automatically trade name, inventory, unit price, weight
Breath.
It is understood that for those of ordinary skill in the art, it can be conceived with the technique according to the invention and done
Go out other various corresponding changes and deformation, and all these changes and deformation should all belong to the protection model of the claims in the present invention
It encloses.
Claims (8)
1. a kind of bom inventories uploading system setting is by the method for group sale, which is characterized in that it includes the following steps:
S1, merchandise news in inventory is obtained from supplier's upload inventory;
S2, background system examine inventory, pass through for closing rule commodity;It reports an error for not conforming to rule commodity prompting;
S3, supplier backstage receive the handling result of return, and inventory content is changed in the upper miscue passed on a skill of craft to others according to return, if
It is uploaded again after putting group quantity;
S4, background system detection inventory;The group quantity G values of each row of data are detected, work as G>=2, system automatic conversion commodity
Title N, commodity weight W, commodity stocks S, commodity price P values;
S5, background system detect after, carry out commodity restocking sale.
2. bom inventories uploading system setting as described in claim 1 is by the method for group sale, which is characterized in that
The step S1 merchandise newss include trade name, brand, encapsulation, lot number, brief introduction, commodity weight, commodity stocks, quotient
Product price, commodity remarks, minimum lot-size, group incremental data.
3. bom inventories uploading system setting as described in claim 1 is by the method for group sale, which is characterized in that
Detection content is in the step S2:
Trade name, commodity weight, commodity stocks, commodity price are that must fill out,
Commodity weight, commodity stocks, commodity price are number;
Trade name, brand, encapsulation, lot number, brief introduction are English or number;
Price only retains two-decimal, it is impossible to less than 0.2 yuan;
Excel document is converted into database data by background system, and returns to handling result.
4. bom inventories uploading system setting as described in claim 1 is by the method for group sale, which is characterized in that
Conversion formula is in the step S4:
N=n+G+pcs, wherein N are trade name, and n is former trade name, and G is a group quantity, and pcs is unit abbreviation)
W=w x G round up and retain three position decimals, and wherein W is commodity weight, and w is former commodity weight, and G is group quantity;
S=s/G, round numbers, wherein downward fetch bit, S are commodity stocks, and s is former commodity stocks, and G is group quantity;
P=p x G round up and retain two-decimal, and wherein P is commodity price, and p is former commodity price, and G is group quantity.
5. a kind of bom inventories uploading system setting is by the system of group sale, which is characterized in that it includes such as lower unit:
Merchandise news acquiring unit obtains merchandise news in inventory for being uploaded in inventory from supplier;
Inventory verification unit for examining inventory by background system, passes through for closing rule commodity;For not conforming to rule
Commodity prompting reports an error;
Inventory setting unit, for receiving the handling result of return on supplier backstage, upper successor according to the miscue of return,
Inventory content is changed, is uploaded again after setting group quantity;
System detectio unit detects inventory for passing through background system;The group quantity G values of each row of data are detected, work as G>=
2, system automatic conversion trade name N, commodity weight W, commodity stocks S, commodity price P values;
Restocking sales unit after being detected in background system, carries out commodity restocking sale.
6. bom inventories uploading system setting as claimed in claim 5 is by the system of group sale, which is characterized in that
The merchandise news acquiring unit merchandise news include trade name, brand, encapsulation, lot number, brief introduction, commodity weight,
Commodity stocks, commodity price, commodity remarks, minimum lot-size, group incremental data.
7. bom inventories uploading system setting as claimed in claim 5 is by the system of group sale, which is characterized in that
Detection content is in the inventory verification unit:
Trade name, commodity weight, commodity stocks, commodity price are that must fill out,
Commodity weight, commodity stocks, commodity price are number;
Trade name, brand, encapsulation, lot number, brief introduction are English or number;
Price only retains two-decimal, it is impossible to less than 0.2 yuan;
Excel document is converted into database data by background system, and returns to handling result.
8. bom inventories uploading system setting as claimed in claim 5 is by the system of group sale, which is characterized in that
Conversion formula is in the system detectio unit:
N=n+G+pcs, wherein N are trade name, and n is former trade name, and G is a group quantity, and pcs is unit abbreviation)
W=w x G round up and retain three position decimals, and wherein W is commodity weight, and w is former commodity weight, and G is group quantity;
S=s/G, round numbers, wherein downward fetch bit, S are commodity stocks, and s is former commodity stocks, and G is group quantity;
P=p x G round up and retain two-decimal, and wherein P is commodity price, and p is former commodity price, and G is group quantity.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711471929.2A CN108133346A (en) | 2017-12-28 | 2017-12-28 | The method and system that the setting of bom inventories uploading system is sold by group |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711471929.2A CN108133346A (en) | 2017-12-28 | 2017-12-28 | The method and system that the setting of bom inventories uploading system is sold by group |
Publications (1)
Publication Number | Publication Date |
---|---|
CN108133346A true CN108133346A (en) | 2018-06-08 |
Family
ID=62393580
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201711471929.2A Pending CN108133346A (en) | 2017-12-28 | 2017-12-28 | The method and system that the setting of bom inventories uploading system is sold by group |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108133346A (en) |
Citations (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1432950A (en) * | 2002-01-14 | 2003-07-30 | 英业达股份有限公司 | Realizing method of enterprise-to-enterprise web site commodity list purchasing mode |
CN101840559A (en) * | 2010-04-26 | 2010-09-22 | 常州市贝海网络技术有限公司 | Online international commodity trading system |
CN102841906A (en) * | 2011-06-24 | 2012-12-26 | 阿里巴巴集团控股有限公司 | Integrated transaction processing system and transaction processing method |
CN103870960A (en) * | 2012-12-10 | 2014-06-18 | 腾讯科技(深圳)有限公司 | Commodity publishing method, terminal, server and system |
CN103870946A (en) * | 2014-03-18 | 2014-06-18 | 沈阳化工大学 | Supermarket invoicing system |
CN105225117A (en) * | 2014-06-24 | 2016-01-06 | 北京七品科技有限公司 | The method that commodity are concluded the business online in batches |
WO2016199405A1 (en) * | 2015-06-09 | 2016-12-15 | 日本電気株式会社 | Shelf allocation assistance device, shelf allocation assistance system, shelf allocation assistance method, and recording medium |
CN106528701A (en) * | 2016-10-26 | 2017-03-22 | 广东广新信息产业股份有限公司 | Cross-border commodity information sending method and system |
-
2017
- 2017-12-28 CN CN201711471929.2A patent/CN108133346A/en active Pending
Patent Citations (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1432950A (en) * | 2002-01-14 | 2003-07-30 | 英业达股份有限公司 | Realizing method of enterprise-to-enterprise web site commodity list purchasing mode |
CN101840559A (en) * | 2010-04-26 | 2010-09-22 | 常州市贝海网络技术有限公司 | Online international commodity trading system |
CN102841906A (en) * | 2011-06-24 | 2012-12-26 | 阿里巴巴集团控股有限公司 | Integrated transaction processing system and transaction processing method |
CN103870960A (en) * | 2012-12-10 | 2014-06-18 | 腾讯科技(深圳)有限公司 | Commodity publishing method, terminal, server and system |
CN103870946A (en) * | 2014-03-18 | 2014-06-18 | 沈阳化工大学 | Supermarket invoicing system |
CN105225117A (en) * | 2014-06-24 | 2016-01-06 | 北京七品科技有限公司 | The method that commodity are concluded the business online in batches |
WO2016199405A1 (en) * | 2015-06-09 | 2016-12-15 | 日本電気株式会社 | Shelf allocation assistance device, shelf allocation assistance system, shelf allocation assistance method, and recording medium |
CN106528701A (en) * | 2016-10-26 | 2017-03-22 | 广东广新信息产业股份有限公司 | Cross-border commodity information sending method and system |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US10896399B2 (en) | Dynamic code assignment for international shipment of an item | |
JP4827560B2 (en) | Method for confirming contents of container, apparatus for confirming transport object, and computer program | |
US10510037B1 (en) | Measuring device and system for freight rate optimization | |
WO2008128042A2 (en) | Method and computer program product for providing paperless customs documentation | |
US11599844B2 (en) | Parcel shipping screening and validation | |
CN107464081A (en) | One kind exempts from unpack formula goods delivery method, system and terminal | |
US8957970B1 (en) | Receiving items into inventory | |
CN106528701B (en) | Cross-border merchandise news sending method and system | |
CN108921654A (en) | Order data processing method, device and computer readable storage medium | |
CN108764942A (en) | A kind of Transaction Information returns control method for anti-counterfeit and system | |
JP6850451B2 (en) | Agricultural traceability system | |
CN109685980A (en) | A kind of gravity sensing automatic selling counter commodity arrangement method | |
JP6150563B2 (en) | Distribution container management apparatus, distribution container management method, and distribution container management program | |
US20220083943A1 (en) | Systems and methods for order fulfillment, common order pack lists, multi-item order packing, and shipping rate automation | |
US8622294B1 (en) | Method and apparatus for electronically organizing transport documents | |
JP2008297086A (en) | Id reading device, id reading method, id reading program, and inspecting device | |
JP5602591B2 (en) | Traceability management system | |
CN108133346A (en) | The method and system that the setting of bom inventories uploading system is sold by group | |
US20080255864A1 (en) | Method and computer program product for creating on demand commercial shipping invoices | |
US20120323766A1 (en) | Method for recycling scrap | |
US11651329B2 (en) | Machine readable technologies for the smart shipping of multiple products | |
EP1653402A1 (en) | A method for performing a customs procedure | |
WO2022029834A1 (en) | Data processing device, data processing method, and program | |
CN107633429A (en) | Shared box for material circulation pricing method, apparatus and system | |
CN109118159A (en) | A kind of self-verifying method and device of clearance data |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20180608 |
|
WD01 | Invention patent application deemed withdrawn after publication |