Main Scripts
Dropshipping Script

14min
This script is used to automate the dropshipping process for dropshippers working with clients. Concept is to automate the process of dropshipping from Linnworks Account to the dropshipper. The script will automatically search for orders on linnworks, export them to a dropbox folder, and then automatically send email of the orders to the dropshipper. The dropshipper will then send the tracking number back to the script, which will then update the tracking number on linnworks.
All scripts for this are similar, for the sake of Documentation we will use Complete Automotive Dropship.
Installation
Clone the repository and install the dependencies
Shell
git clone https://github.com/E-MPS-CO-UK/CompleteAutomotiveDropship
cd CompleteAutomotiveDropship
python3 -m venv venv
source venv/bin/activate
pip install -r requirements.txt
git clone https://github.com/E-MPS-CO-UK/CompleteAutomotiveDropship
cd CompleteAutomotiveDropship
python3 -m venv venv
source venv/bin/activate
pip install -r requirements.txt
﻿
Create a new file called .env and add the following variables
Shell
Clientid = # Dropbox Client ID
Clientsecret = # Dropbox Client Secret
refreshtoken = # Dropbox Refresh Token

hostname = #host
email = # client email address
emailpassword = # client email password
sending_email = # dropshipper email address
Clientid = # Dropbox Client ID
Clientsecret = # Dropbox Client Secret
refreshtoken = # Dropbox Refresh Token

hostname = #host
email = # client email address
emailpassword = # client email password
sending_email = # dropshipper email address
﻿
Run the script
Shell
python3 main.py
python3 main.py
﻿
Code Structure
Script Structure
Shell
.
├── README.md
├── app
│   ├── __init__.py
│   ├── config.py
│   ├── db_config.py
│   ├── downloadmail.py
│   └── sendmail.py
├── config.ini
├── main.py
├── pyproject.toml
├── requirements.txt
├── tests
│   ├── __init__.py
│   ├── test_sendmail.py
│   └── test_shipsmail.py
└── tox.ini
.
├── README.md
├── app
│   ├── __init__.py
│   ├── config.py
│   ├── db_config.py
│   ├── downloadmail.py
│   └── sendmail.py
├── config.ini
├── main.py
├── pyproject.toml
├── requirements.txt
├── tests
│   ├── __init__.py
│   ├── test_sendmail.py
│   └── test_shipsmail.py
└── tox.ini
﻿
Documentation
Configuration Module
This module contains the configuration variables and File paths used in the script. For every droshipper, you must add new configuration variables
Dropbox configuration
dropbox_connect() - this function is used to establish a connection with Dropbox. It returns a Dropbox object that can be used for further operations.
Python
def dropbox_connect() -> Dropbox:
    try:
        endpoint = os.environ["endpoint"]
        query_params = {
            "grant_type": "refresh_token",
            "client_id": os.getenv("client_id"),
            "client_secret": os.getenv("client_secret"),
            "refresh_token": os.getenv("refresh_token")
        }
        response = requests.post(endpoint, params=query_params,
                                 timeout=60).json()
        dbx = dropbox.Dropbox(response['access_token'])
    except AuthError as e:
        print('Error connecting to Dropbox with access token: ' + str(e))
    return dbx
def dropbox_connect() -> Dropbox:
    try:
        endpoint = os.environ["endpoint"]
        query_params = {
            "grant_type": "refresh_token",
            "client_id": os.getenv("client_id"),
            "client_secret": os.getenv("client_secret"),
            "refresh_token": os.getenv("refresh_token")
        }
        response = requests.post(endpoint, params=query_params,
                                 timeout=60).json()
        dbx = dropbox.Dropbox(response['access_token'])
    except AuthError as e:
        print('Error connecting to Dropbox with access token: ' + str(e))
    return dbx
﻿
send email module
downloadfromdbx - This function uses the dropbox object to download files from Dropbox to a local path.
Python
dbx = dropbox_connect()
dbx.files_download_to_file(local_path, download_path)
dbx = dropbox_connect()
dbx.files_download_to_file(local_path, download_path)
﻿
send_to_db - This function is used to save new oprders from a CSV file to a SQLite database.
send_email - This function is used to send emails to the Dropshipper if there are any new Orders.
Code snippet
Python
send_from = username
send_to = recipient_email
msg = MIMEMultipart()
msg['From'] = send_from
msg['To'] = send_to
msg['Date'] = formatdate(localtime=True)
msg['Subject'] = 'Open Orders'
with open(file_path, 'rb') as fp:
    part = MIMEBase('application', 'text/csv')
    part.set_payload(fp.read())
    encoders.encode_base64(part)
    part.add_header('Content-Disposition', 'attachment',
                    filename='Orders(AAP).csv')
    msg.attach(part)
with smtplib.SMTP_SSL('send.one.com', 465) as smtp:
    smtp.login(username, password)
    smtp.sendmail(username, send_to, msg.as_string())
send_from = username
send_to = recipient_email
msg = MIMEMultipart()
msg['From'] = send_from
msg['To'] = send_to
msg['Date'] = formatdate(localtime=True)
msg['Subject'] = 'Open Orders'
with open(file_path, 'rb') as fp:
    part = MIMEBase('application', 'text/csv')
    part.set_payload(fp.read())
    encoders.encode_base64(part)
    part.add_header('Content-Disposition', 'attachment',
                    filename='Orders(AAP).csv')
    msg.attach(part)
with smtplib.SMTP_SSL('send.one.com', 465) as smtp:
    smtp.login(username, password)
    smtp.sendmail(username, send_to, msg.as_string())
﻿
Download Mail Module
download_from_mail - This function is used to download attachments from unread emails. It fetches all unread messages and marks them as read.
Python
mail = Imbox(host, username=username, password=password)
messages = mail.messages(unread=True)
for (uid, message) in messages:
    mail.mark_seen(uid)
    for idx, attachment in enumerate(message.attachments):
        try:
            att_fn = attachment.get('filename')
            download_path = f"{download_folder}/{att_fn}"
            with open(download_path, "wb") as fp:
                fp.write(attachment.get('content').read())
        except Exception as download_error:
            logging.info('Error downloading attachment: %s',
                         download_error)
mail.logout()
mail = Imbox(host, username=username, password=password)
messages = mail.messages(unread=True)
for (uid, message) in messages:
    mail.mark_seen(uid)
    for idx, attachment in enumerate(message.attachments):
        try:
            att_fn = attachment.get('filename')
            download_path = f"{download_folder}/{att_fn}"
            with open(download_path, "wb") as fp:
                fp.write(attachment.get('content').read())
        except Exception as download_error:
            logging.info('Error downloading attachment: %s',
                         download_error)
mail.logout()
﻿
upload_to_dropbox - This is uses the dropbox object to upload the downloaded files to a dropbox.
Python
with open(file_path, 'rb') as f:
    dbx.files_upload(f.read(), dest_path,
    mode=dropbox.files.WriteMode.overwrite,
    mute=True)
with open(file_path, 'rb') as f:
    dbx.files_upload(f.read(), dest_path,
    mode=dropbox.files.WriteMode.overwrite,
    mute=True)
﻿
This is a general overview of the Dropshipping Script. With the Information provided you will be able to run the script seamlessly.
﻿
Updated 25 Mar 2024
Did this page help you?
Refund & Exchange & Split Order Script
Custom Order Processing Script Documentation