Virtual Assistant (Shopify & Cost Accounting Specialist)

Job Responsibilities:

Add new products, create variants, and update existing product listings in Shopify.
Create and manage tags and collections in Shopify.
Update menus and content in Shopify, including adding new brands, creating collections, and integrating them into the navigation menu.
Generate and manage purchase orders in Shopify.
Handle customer service tasks, including order tracking, filing claims with shipping companies, and organizing customer emails that require staff assistance.
Assist with inventory forecasting to ensure stock availability.
Basic coding knowledge for Shopify themes is a plus.
Graphic design skills for email campaigns, web banners, and social media posts are a plus.

10-15 hours a week

Please complete the case study below to be considered for the interview shortlist.

Attached is an invoice that is in USD (see file link below)

Upgrade to see actual info

(Ignore bottom part where it says custom invoice would look like this etc)

I need to calculate my cost for each product (individual not box) to include the shipping + add the exchange rate I was charged in $CAD

My card was charged in 2 payments:
$861.04 (USD) = $1290.75 CAD conversion rate charged 1.499059
$1087.00 (USD) = $1629.48 CAD conversion rate charged 1.499061

In an excel please write what each line item (singles not box) would come to in $CAD + the shipping cost per item ($367 usd at the end but divide by total number of units) in $CAD (singles not box) = total cost in $CAD per item (not box).

Example: The first line turkey there are 12 per box and i ordered 2 boxes so i need to know what each individual cost comes to in $CAD including the shipping that was charged

Please email the completed case study to Upgrade to see actual info with Subject line: Virtual Assistant (Shopify & Cost Accounting Specialist)

Thank you!