In Progress

Automatically add order details to spreadsheet from SKU - Apple Automator / Applescript / Excel

I sell graphic t-shirts, hoodies, tanks, etc and I receive orders via email. When the order comes in I look at the SKU (or the description) and I extract all the information I need from that and fill in the appropriate spreadsheets. At the end of the day I then know how many graphics to print and what shirts/colors/sizes to order (see attached images). This works out really good except that it leaves room for human error. I'm looking for someone who can write some AppleScript, use Apple Automator, or some script in Excel to make this happen. I would like to simply copy the SKU from the email and paste it somewhere else and all the details will be extracted and added to the spreadsheet for me automatically.

All the information that I need is in the SKU. Here is an example SKU:

BEETS_G185_M_BLAC

“BEETS” is the graphic

“G185” is the style

“M” is the size

“BLAC” is the color

The only thing that isn't quite specific in the SKU is in the graphic section. I actually have 3 different colors for the BEETS graphics, and that color is determined by the color of the shirt that is in the order (in this example it's BLAC). I have a unique SKU for every single variation of every t-shirt, hoodie, etc that I sell.

I need something that is scalable as I'm constantly adding new graphics and styles (apparel) to the mix.

Finally, I prefer to use Apple Numbers instead of Microsoft Excel. If absolutely necessary though, I can use Excel (but I prefer not to).

Skills: Applescript, Excel

See more: excel sku spreadsheet, toast save disk image applescript, applescript export freehand pdf, freelance programmer applescript, applescript dvd creator, toast applescript create image, toast applescript dvd, cocoa carbon applescript, generating html photoshop applescript, list dvd applescript, toast dvd applescript, applescript dvd grab, excel turn spreadsheet macro, rent excel scenario spreadsheet, oscommerce add order status, applescript myspace plays, oscommerce add order note, create rule mail applescript, add order form website, eplain excel budget spreadsheet stock symbols, carbon applescript, port excel vba spreadsheet website, soccer excel blank spreadsheet league, excel csv automaticly add, vba excel code install add ins

About the Employer:
( 8 reviews ) Lincoln Park, United States

Project ID: #11710841

Awarded to:

someka

Hello. What you need can be perfectly done in Excel (I know you dont prefer) But, it may also work in Mac version. What we will do is put the data structure in the background then all you have to do is put the SKU and More

$84 USD in 3 days
(103 Reviews)
6.7

3 freelancers are bidding on average $82 for this job

mantislin

Dear sir, I am scraping expert, I have did too many scraping projects, please check my reviews then you will know. Can you tell me more details? then I will provide example data/script for you. Thanks, More

$82 USD in 2 days
(59 Reviews)
6.1
schoudhary1553

Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. We hav More

$80 USD in 2 days
(45 Reviews)
4.9