Hello everyone, I'm hoping this post is in the correct spot, it touches on a few different areas.
The company I work for just set up an e-commerce site a few months ago. Customers can go on our website, order from our product line, and check out with credit card using authorize.net. When the customer orders, I get an email from authorize.net with their payment/shipping information, and I get an email from our website also containing their billing/shipping info, the item they ordered and the SKU corresponding to that item.
Our product is custom built, so basically lets say it's a window. The window comes in 7 different sizes. The customer chooses a size. Then they choose from 3 types of glass. Then they choose from two colors for trim. Then they can choose from two types of curtain rods to accompany it.
Once the customer builds and purchases the item, I get the email breaking down their order.
5 foot by 2 foot window, shatter proof panes, walnut stained trim, 6" curtain rod.
that combination of components corresponds to this SKU 5X2WSPPWT6R
Then I open an excel form, RE-TYPE the name, billing info, shipping info, date ordered. I choose each component from poorly made excel drop downs until i've re-created the order from the email in excel. This order form is uploaded to salesforce for job tracking, then printed and handed to our shop foreman who uses it to build the job.
The time spent re-entering and typing all this information is eating into valuable lead time. Is there a way to automate this process? To take the SKU and enter it into an excel for, and have the SKU automatically pull up the correct components? Is there a better way than using excel? Is there a way to automate it full, so when an email comes in with an order I can just drag it into salesforce or some other program, and that order is generated on its own? I really need help here. I'm just a graphic designer/account manager here, but this is a problem that really needs to be addressed. Any help is appreciated! Thanks guys/girl!
The company I work for just set up an e-commerce site a few months ago. Customers can go on our website, order from our product line, and check out with credit card using authorize.net. When the customer orders, I get an email from authorize.net with their payment/shipping information, and I get an email from our website also containing their billing/shipping info, the item they ordered and the SKU corresponding to that item.
Our product is custom built, so basically lets say it's a window. The window comes in 7 different sizes. The customer chooses a size. Then they choose from 3 types of glass. Then they choose from two colors for trim. Then they can choose from two types of curtain rods to accompany it.
Once the customer builds and purchases the item, I get the email breaking down their order.
5 foot by 2 foot window, shatter proof panes, walnut stained trim, 6" curtain rod.
that combination of components corresponds to this SKU 5X2WSPPWT6R
Then I open an excel form, RE-TYPE the name, billing info, shipping info, date ordered. I choose each component from poorly made excel drop downs until i've re-created the order from the email in excel. This order form is uploaded to salesforce for job tracking, then printed and handed to our shop foreman who uses it to build the job.
The time spent re-entering and typing all this information is eating into valuable lead time. Is there a way to automate this process? To take the SKU and enter it into an excel for, and have the SKU automatically pull up the correct components? Is there a better way than using excel? Is there a way to automate it full, so when an email comes in with an order I can just drag it into salesforce or some other program, and that order is generated on its own? I really need help here. I'm just a graphic designer/account manager here, but this is a problem that really needs to be addressed. Any help is appreciated! Thanks guys/girl!