Lukket

Create a program -script - process to automate process of keying in ordered particular into courier doket

First of all please view the requirement video explanation

[url removed, login to view]

Download requirement files:

[url removed, login to view]

I am an online seller on shopee

To ship out orders , shopee provide us with

1) Shopee Poslaju Waybill1 – which is the courier dokets

2) Shopee Packlist – which contains the items that the buyer purchased based on the order no

We are currently manually adding/editing using adobe acrobat XI [url removed, login to view] , the items that the buyer (shopee packlist) purchased , manually to Shopee Poslaju Waybill1 .

What we currently do :

1) open up Shopee Poslaju Waybill1

2) for each specific order in Shopee Poslaju Waybill1 example- Order ID: 17091812131CK81

3) we open up Shopee Packlist – find for Order ID: 17091812131CK81

4) look in Shopee Packlist Order ID: 17091812131CK81- the item purchased and then manually edit Shopee Poslaju Waybill1 by placing information of the items purchased for Order ID: 17091812131CK81.

As space is limited, we will write the items purchased in short form together with calculation of total items purchased if item purchase is more than 1 .

I need a program/script that can automate this process.

Requirement of the automated program/script:

1) It should have a database that prompt us with on what short description to record for a particular item.

Example :

Shopee pack list -

Order ID 1709161940179DY

Item purchased –

Name /Product Description Variation /Option Quantity

Portable Steam Iron Inns Tobi

Travel Steamer (LOWEST + FREE

SHIPPPING)

ORIGINAL TOBI

1

We cannot copy the entire product description plus option to the Shopee Poslaju Waybill1 (courier doket ) because it is too long

Too length to copy entire below to Shopee Poslaju Waybill :

Portable Steam Iron Inns Tobi Travel Steamer (LOWEST + FREE SHIPPPING).Origibak Tobi– 1

Instead we use short description

TobiSt-1

Name /Product Description Variation /Option Quantity

Portable Steam Iron Inns Tobi

Travel Steamer (LOWEST + FREE

SHIPPPING)

ORIGINAL TOBI

1

Aluminium / PU Leather Watch

Case Box 6 10 12 20 24 Slot 6 slot aluminium

1

Aluminium / PU Leather Watch

Case Box 6 10 12 20 24 Slot 6 slot pu

1

We will record this as

TobiSt-1,6Alu-1,6Pu-1 *T:3

And copy over to Shopee Poslaju Waybill according to the order no

The program or script should refer to the database on what short description to place – together with quantity purchased .

It should

short description -no of item, short description -no of item and then sum the total no of products if quantity more than 1item *T:_

Example: TobiSt-1,6Alu-1,6Pu-1 *T:3

It will automatically copy TobiSt-1,6Alu-1,6Pu-1 *T:3 to Shopee Poslaju Waybill base on order number .

It should have a database similar to the below

(refer to requirement files downloadlink above)

- At the end of processing , the system/script should inform if any order no in Shopee Poslaju Waybill1 – unable to find the particular order in Shopee Packlists

You can code in any type of platform , excel macro , java , cb and etc as long as it does the work

My operating system:

-Windows 10 pro

-Adobe acrobat XI [url removed, login to view]

-Excel 2013

Færdigheder: C++ Programmering, Excel Macros, Excel VBA, Java

Se mere: create program for extract product data from particular online shop 2, create program for extract product data from particular online shop -- 2, script automate mysql create, create sql script, free cash program script, create database script, create program automatically run usb, coupon software program script, create program increases youtube views visual basic, create program compares files, create logon script server 2003 sets background, centos create startup script, php create subdomain script

Om arbejdsgiveren:
( 25 bedømmelser ) Selangor, Malaysia

Projekt-ID: #15197000

7 freelancere byder i gennemsnit $73 for dette job

schoudhary1553

Greeting, I am the expert freelancer here and can deliver your project with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 8 years of experience C++ Progra Mere

$150 AUD in 2 dage
(15 bedømmelser)
4.7
Xeeshanah

Hello there, Read your project description and i can provide you the work that you need. I'm a professional computer scientist from Pakistan. Relevant Skills and Experience I've proficiency in multiple languages with Mere

$80 AUD på 1 dag
(12 bedømmelser)
4.0
AhmedHassan1122

Excel Expert . Can automate this task according to your requirements. Relevant Skills and Experience Automation and Excel Expert Proposed Milestones $111 AUD - Full price

$111 AUD på 1 dag
(5 bedømmelser)
3.0
abhinovpankaj

I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Relevant Skills and Experience VBA and Excel,Word,Office Applications -- Expert on C# usin Mere

$77 AUD in 5 dage
(2 bedømmelser)
2.5
creativesols3

Great expertise in web applications development mainly on PHP, (Joomla, Wordpress, Codeigniter, Cake PHP), .NET, Asp.NET, Vb.NET, HTML 5 etc.& mobile apps Relevant Skills and Experience Great expertise in web applica Mere

$31 AUD på 1 dag
(0 bedømmelser)
0.0
$25 AUD på 1 dag
(0 bedømmelser)
0.0
$40 AUD in 2 dage
(0 bedømmelser)
0.0