1. Establish contact
Potential suppliers can contact us through various media. Send us the necessary information.
2. View samples
3. Cooperation negotiation
The supplier sends basic information such as product name, price, and samples to e-commerce A. E-commerce A will communicate with the supplier in detail to determine the price, quantity, etc. of the purchased goods.
4. Enter into a contract
Suppliers who sign a contract can become franchised suppliers, and we will purchase according to demand.
5. Place an order for purchase
According to the contract, the supplier delivers the goods to the e-commerce A logistics center on time and with guaranteed quality and quantity.
6. Sales
After the e-commerce A logistics center confirms the quantity and quality of the incoming goods, the relevant products can be sold overseas on the e-commerce A sales platform.
7. Settlement General tips for supplier information registration form
1: Multi-condition counting
Requirements: Count the number of people in the statistics department who are in production and whose positions are master operators
The formula is:
=COUNTIFS(B2:B9,F2,C2:C9,G2)
The COUNTIFS function counts the number of cells in a conditional area that meet multiple specified conditions. Common usage is:
=COUNTIFS(condition area 1, specified condition 1, condition area 2, specified condition 2...)
2: Conditional search
The VLOOKUP function has always been a favorite among the public. The syntax of the function is:
VLOOKUP (Who to look for, where to look for, which column of content to return, exact or approximate search)
You want to query the position of the employee name in cell F5.
=VLOOKUP($F$5,$B$1:$D$10,2,0)
When using this function, you need to pay attention to the following points:
1. The fourth parameter is generally set to 0 (or FASLE) to search in exact matching mode.
2. The column number in the third parameter cannot be understood as the actual column number in the worksheet, but specifies the column in the search range of the return value.
3. If the search value is inconsistent with the data type of the data area keyword, the error value #N/A will be returned.
4. The search value must be located in the first column in the query area.
Supplier information registration formIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Department daily work schedule,Equipment purchase budget sheetDownload to get the source file, which you can edit, modify and replace. Download the supplier information registration form and go to Huajun Software Park.
Useful
Useful
Useful