The next day, Wu Zhou bought four cups of Starbucks coffee early in the morning! Then he went to the company!

But he was still the first one to arrive in the e-commerce department, four workstations, four cups of coffee!

Some colleagues from other departments around saw Wu Zhou's move, but cast some unexpected eyes!

Obviously, this kind of "human relations" is rare for them!

The workplace of young people is still a little "pure"!

Sure enough, as the working time approached.

Several colleagues from the e-commerce department arrived one after another, and soon found the very obvious Starbucks packaging on their respective seats!

Look around again, other colleagues in the company don't have it, only they have it!

It's clear..

"Xiao Wu, you don't have to be so polite!"

"You are too polite."

Polite on the mouth...

But the heart is still happy, and soon one by one opened the package and drank it! ! !

"I just passed by Starbucks when I came out this morning, and I suddenly wanted to drink, but I thought it would be bad for me to drink alone in the company, so I just wanted to drag you down with me!" Wu Zhou said jokingly in a low voice.

However, everyone knew the intention of Wu Zhou's action, but who doesn't like such a colleague who knows how to deal with things!

After that, Wu Zhou started a new day of work.

Originally, Sun Wenwen was thinking of giving Wu Zhou the backend account next week, but looking at the coffee in her left hand.

I always feel that if I don't show some expression, it seems a bit guilty...

"Xiao Wu, this is our backend address, and this is our backend account password! Please log in first!" Sun Wenwen sent all of this to Wu Zhou through QQ.

Actually, I originally planned to talk about it at least three days later...

"Don't click anything in the backend randomly, don't click on any confirmation, cancellation, modification, etc. If you really accidentally touch it, you must tell me, I will teach you how to download inventory and sales reports..." Sun Wenwen focused on explaining it to Wu Zhou.

Wu Zhou listened to Sun Wenwen's instructions very carefully, and even watched her demonstrate it herself.

"Do you understand? Try it, let me see!" Sun Wenwen was still a little short, and she had been leaning sideways, which was very tiring, so she couldn't see clearly.

She stood up and came behind Wu Zhou.

After that, Wu Zhou downloaded both reports smoothly under Sun Wenwen's eyes.

Then he made the daily sales report and the daily inventory report!

At 9:10, Wu Zhou downloaded the table.

At 9:23, the two tables were already made.

Sun Wenwen gave Wu Zhou a thumbs up.

"Very good, no problem, it seems that I really don't have to worry about these things anymore." Sun Wenwen gave Wu Zhou a big affirmation.

"Sister Wenwen, I'll send you this table as a backup. I'm also worried that if I suddenly take a leave one day, I won't be able to make these tables, which will delay my work. Then I may have to trouble Sister Wenwen. All the formulas in this table are complete. Sister Wenwen, as long as you don't change these formulas, and the format of the inventory and sales tables of Tmall Supermarket remains unchanged in the future, you can download the table from the background every morning, put it here, refresh the data source, and you can directly generate daily reports!" Wu Zhou explained briefly and demonstrated it to Sun Wenwen.

Sure enough, it took 13 minutes to get the results just now, but now it only takes a few seconds...

Sun Wenwen looked at this "amazing efficiency improvement", especially that she could "do it easily".

"Okay, Xiao Wu, I'll back it up. You can also get familiar with the products first, I'll send you the product table!"

"There are many products in our warehouse... and in the conference room! You can go and see, feel it yourself, and try it!"

This matter was just finished.

Sun Wenwen couldn't wait to try it.

However, she was still unsure about some of the processes, so she asked Wu Zhou again.

Wu Zhou also answered her questions very seriously.

After that, she imported the data she had downloaded before one by one and tried...

Seeing that she got the "daily report" so easily, Sun Wenwen gave Wu Zhou a thumbs up!

"Xiao Wu, great!"

But then, Sun Wenwen thought of something else.

"Today we have to contact the logistics and our warehouse to confirm the time to pick up the goods. You can see how I do this process. Don't be stressed. I don't require you to learn it immediately. Just watch it first. Generally, there are no special circumstances.It's only once a week. I just need to do it today. You can take a look. I will teach you next week. "

Because in daily work, a lot of work is about spreadsheets.

Not to mention the daily report, the subsequent order form, appointment form, delivery form, and activity report form, etc. all need to use Excel.

She was also worried that Wu Zhou would learn too much at once and his mind would be confused in the end. After all, she was like this at the beginning... It took a while, and it was only after continuous hands-on operation that she gradually had ideas and distinguished these things.

Sun Wenwen said, and began to show Wu Zhou the whole process of communicating with logistics and warehouses.

Of course, there is a prerequisite step, which is to first determine the delivery according to the inventory daily report made by Wu Zhou. Quantity.

"The inbound order is for the platform, so we must use the platform's inbound order template. The orders we have made need to be changed to the platform's unified inbound order format. The platform supply chain module can directly download the template here... We just need to modify it slightly... Save it... Now import it to the platform... You see, the inbound order appears in the background..."

Sun Wenwen said while operating. Of course, this step sounds troublesome, but it is actually very simple. Just copy and paste.

"After the inbound order is imported, it is in the "unreviewed" state. It needs to be processed by the clerk or clerk on the Alibaba side and operated again to review the process! There is a special supply chain group here..."

Sun Wenwen will explain every step to Wu Zhou, after all, this will be "Wu Zhou's job" in the future.

After sending a message in the supply chain group.

Sun Wenwen began to contact the warehouse to find out what goods she needed, how many, and when to take them away, so that the warehouse could prepare them in advance.

However, this process also involves a "pull and pull process". There are only two people in the warehouse, and they are responsible for sending express from the Tmall store.

At the same time, because the products are all daily necessities, the company "inputs goods without packaging", so the warehouse has to pack them...

Inevitably, they have to yell that they are too busy...

Sun Wenwen's reply was, "I have already talked to the boss, and the boss said they are trying to find a way. You should prepare my goods quickly. After I finish this matter here, I will go to the boss to urge him! ”

After this tug of war, the backend order was also reviewed.

At the same time, it was the last step to make a delivery note for logistics.

Just when Sun Wenwen was about to do it, she suddenly thought of Wu Zhou's outstanding performance in Excel.

"Try this delivery note!"

She briefly talked about the precautions and the desired results, and gave Wu Zhou a template...

Wu Zhou listened and learned very carefully throughout the whole process.

Then I felt inexplicably that it seemed quite easy.

Although Sun Wenwen kept saying "Pay attention to this, pay attention to that! "

But Wu Zhou remembered every step very clearly! And because of Sun Wenwen's explanation, he also knew the reason for each step...

At this moment, Wu Zhou started to get started directly according to Sun Wenwen's requirements and the "delivery order template" given.

In fact, the so-called delivery order is to write a merchant's delivery order according to the format of the logistics side.

You need to fill in the product name, quantity, value, and volume.

Then...

Wu Zhou was right under Sun Wenwen's eyes...

Various shortcut keys on the keyboard...

A logistics delivery table was quickly generated.

"Sister Wenwen, I made this table. Later, we only need to put our outbound order in, and then refresh it in this delivery order sheet, and we can directly generate the corresponding outbound order! "It's just as convenient as the daily report I made this morning."

Sun Wenwen looked at the magical "table" in front of her and suddenly felt that she was "wronged" before. If she had known these things earlier, why would she need to fill in the data one by one so troublesomely!!!

"Xiao Wu, can you teach me this?" After seeing the "magic" on Excel one after another, Sun Wenwen wanted to find Wu Zhou to learn it!!!

Tap the screen to use advanced tools Tip: You can use left and right keyboard keys to browse between chapters.

You'll Also Like