My name is Robert Capla and I am a new member of Seller Union. I am a software engineer and my guides will help you with programming interesting features, which can save you a lot of time and money as Amazon sellers.
This is my first tutorial about programming. Today we are going to use Python to create a bot for Instagram that will automatically send messages to your followers. So we have to start with Python installation. You can easily download it from the official Python page https://www.python.org/. Python is available for Mac, Windows or Linux, installation is very simple but if you see an option to add python into PATH you have to check this option otherwise it will not work correctly. After installation you could try to open your terminal or on Windows cmd and try to write python3 –version, after this you will see the version of your Python and you know your Python is installed properly.
Now everything is ready to start coding, I am using VSCODE to edit code. You could use any editor but I really recommend using VSCODE because it’s free and supports almost every programming language. You could download it here https://code.visualstudio.com/.
So we will start to collect our followers into some text file, for this we will use the library instaloader, this library supports many features like download images, get profile data, and many more but today we will use a function that will get usernames who follow us. To start using this library you have to use this command pip3 install instaloader.
Firstly we have to code a program that login into our Instagram account. This code asks us for a username, password and limit how many users we want to store. I highly recommend that you don’t write more than 300 per day. Also there are created error handlers so if the username doesn’t write a number or insert a bad username or password it will ask again for entering these inputs.
So now we can continue storing usernames into a text file. So we add these lines of codes and we have our followers stored into the text file. And the program for storing usernames of our followers is ready now. We can continue to send messages to these users.
Now we can continue to create a new python file and in this file we will read usernames and send messages to our followers. For the first program I used the name “get_usernames.py” for this program I will use “send_message.py”.
First we have to install selenium so use command pip3 install selenium, this python library allows you to control the web browser. After successful installation we have to download the Chrome driver because Google Chrome is very easy to control. You can download it on this link https://chromedriver.chromium.org/. That’s why I prefer Google Chrome when i am using selenium. You have to check your chrome version on this link and by that you have to download the same version of chrome driver. After you downloaded the Chrome Driver creator folder in the same folder where you have these 2 python scripts, call that folder “drivers”, and insert that driver into that folder. Now we are ready to start coding.
Firstly we have to import important libraries, so we need from selenium webdriver, and Keys, and also we need random and time because we need randomize our script because otherwise it will be suspicious and our account will be suspended, also we need some for username password and message to send, by this way we can easily send message from many accounts and don’t need to change always code, when it will be hardcoded. Then our program needs to read our usernames so it reads line by line by line and saving usernames into the list now is very easy for us to work with this data.
Now we have to create a function that login into our Instagram account, this function open page instagram.com and tries to click on cookies popup we have to use try, because when there will not be that popup our program will crash, there is command except that command define what will happened if program can’t do something but right now we use just command pass so nothing will happened, and then our program find inputs on page for username and password and insert values into that inputs after program successfully wrote password it simulate Enter.
Now we have created a function for sending a message and our program is ready, so there it is, there is nothing special so there is code.
And now last thing, we have to call our functions and run our script so we insert these lines of code and it’s finished.
You can download the full code here https://github.com/RandoS-svk/Instagram-Dm-Bot and we will prepare a service for you that will work if you are bored of programming it. If you like this post leave a comment.
I hope you found this article helpful. Please feel free to leave a comment. Many Amazon sellers recently started trading stocks and crypto currencies, hoping to diversify their income, which is a very good idea with all the uncertainty which comes with the platform. For this reason, we launched a new Facebook group, Crypto Arbitrage Income (Bitcoin, Crypto, Altcoins, Blockchain, Trading) – feel free to join us and forget about the troubles of selling on Amazon for a moment!
If you are an Amazon Seller who needs help with any Amazon-related issues such as suspensions, listing blocks or is looking for professional assistance, please don’t hesitate to subscribe to Kika Angelic’s new OnlyFans page at: www.onlyfans.com/kikaangelic
How to reconcile invoices in Xero with incoming deposits from the sales channel
Once you have sent a settlement to Xero you will be able to reconcile the settlement against the disbursement Amazon, eBay, Shopify or Etsy will have paid out to your bank account.
If you need guidance on how to send your settlements to Xero from Link My books read this help article.
The good thing about settlement based accounting is that when you do so the amount shown on the invoice in Xero and the amount you receive into your bank from the sales channel will be exactly the same. This makes it really easy for you (or your accountant) to reconcile your bank account.
All you need to do is locate the deposit on your bank statement reconciliation in Xero and click on the OK button, as shown below:
This will work for settlements in your home currency, so if the invoice is in GBP and your bank account is in GBP too.
IMPORTANT – If the currency of the invoice is different to that of the bank account, then follow the instructions in this article on How to reconcile foreign currency settlements.
Why are some of my settlements being sent as bills instead of invoices to Xero?
When Link My Books sends your Amazon settlements to Xero we do so in the form of an invoice (almost always).
You may have noticed that we sometimes send your settlement (or part of it) as a bill instead of an invoice and wondered why we do that…
Since Xero does not allow negative total invoices, if you have a settlement which is for a negative amount then we have no choice but to send it as a bill instead.
Why would I have a negative invoice for a settlement?
There are two main reasons as to why you may have seen this happen in your Link My Books account.
- You have a negative settlement. This can occur if your Amazon fees and advertising costs are larger than your sales amount. In this case Amazon will actually charge your card on file with the settlement amount and produce a negative total settlement report.
- If you have a settlement that spans two months and you also have a large reserved balance by Amazon. In this case we split the settlement by month so we create two invoices but because the reserved balance will always fall in one or the other invoice it will end up meaning that one of your invoices will be for a negative total.
How to reconcile foreign currency settlements through Xero
Reconciling foreign currency settlements against their local currency amounts in Xero differs depending on whether you use Amazon currency conversion tool or not.
If you have entered your GBP bank account as the deposit account for all your Amazon funds, including those in EUR, USD and CAD, then Amazon will use their Amazon Currency Conversion platform to convert your EU, USD or CAD payments into GBP before they pay them out to you.
If you have added local bank accounts for each of the different currencies that Amazon uses then they will pay you out in those currencies without first converting them to GBP.
If you are using the Amazon Currency Conversion platform then when your settlements are sent to Xero we will add their converted amounts to the invoice references like this:
“(€5.79) LMB-FR-1012345678-1 (converted to GBP 4.88)”
This makes it easier to find and match the foreign currency settlements with their GBP bank lines.
To do so if you take the amount you received in GBP and simply search for that value in the reference search box and untick the show GBP items only box, then Xero will show the invoices which have that figure in the reference which should make it much easier to identify them.
The steps are:
- Click the “Match” tab
- Un-tick the “Show GBP items only” checkbox
- Copy the amount you received in GBP and paste it into the “Search by name or reference” box
- Click “Go”
- Tick the invoice and hit reconcile.
Should you be worried when your ODR exceeds the 1% target?
Many Amazon Sellers are contacting me through my OnlyFans page daily, seriously worried about their Seller Accounts being labelled as ”At Risk” of deactivation. But does this orange warning status actually mean anything bad? Learn more in this article!
Amazon has their minimum performance targets for Order Defect Rate, Cancellation Rate, Late Shipment Rate and many other metrics. Whenever a Seller Account exceeds the maximum permissible defect rate, a warning will appear.
Typically, the affected seller will also receive the following e-mail from Amazon Seller Performance:
|Warning: Your order defect rate is higher than 1%|
We have identified that your Order Defect Rate has exceeded the target rate. If this problem continues, it may result in account deactivation.
Why did I receive this message?
We have taken this measure because your Order Defect Rate has exceeded the target of 1%. Order Defect Rate is the percentage of all orders that result in negative feedback, an A-to-z Guarantee claim that is not denied, or a credit card chargeback out of total orders during a given 60-day time period. Amazon’s Order Defect Rate policy can be found at: https://sellercentral.amazon.com/gp/help/200285170.
We’re here to help
If you have questions about this policy or your account, or believe that this was sent in error, please contact us at https://sellercentral.amazon.com/cu/contact-us.
What can I do to avoid account deactivation?
Please ensure that you no longer violate the above policy. Review your orders to determine the cause of the issues contributing to your Order Defect Rate. You can appeal any A-to-z claim, negative customer feedback, or service chargeback that you believe should not be counted in your Order Defect Rate by visiting the following links:
— Appeal A-to-z Claims: https://sellercentral.amazon.com/gp/help/G202041210
— Request removal of seller feedback: https://sellercentral.amazon.com/gp/help/20231
— Appeal Chargeback Claims: https://sellercentral.amazon.com/gp/help/202145040
You do not need to submit a plan of action to us at this time.
You can view your account performance at https://sellercentral.amazon.com/performance/dashboard?reftag=ah_em_op or by selecting Account Health on the home screen of the Amazon Seller app on your iOS or Android device. The Account Health page shows how well your account is performing against the performance metrics and policies required to sell on Amazon.
Seller Performance Team
In regards to Order Defect Rate, Late Shipment Rate or Cancellation Rate, if you are a small seller, your metrics will typically greatly exceed the targets following a single defective order. Seeing this on your Account Health Dashboard can be quite alarming.
However, please note that no Seller Account will get suspended over 1-2 or 3 defects. Amazon can see, that you are a small seller. Even if you have a 50% Order Defect Rate with 1 defective order out of two, you are not worse off than someone with an 1.02% ODR!
Many Amazon Sellers wrongly believe, that the best approach is to try to get into touch with the buyer at all costs and make them withdraw the A-Z claim or negative feedback. They are trying to achieve this by offering free items, full refunds or even extra credits issued on the top of a full refund.
Doing this is a terrible idea, as it can be picked up by Amazon’s automated bots as a serious violation of their Seller Code of Conduct. My advice is to never contact buyers who left a negative feedback or opened a valid A-Z claim in an attempt to have the defect removed. The best thing you can do is avoid getting additional defects and complaints by learning from your mistakes and implementing preventative measures.
Amazon Seller News2 years ago
Account deactivated in accordance with section 3 of Amazon’s Business Solutions Agreement
Amazon Seller News2 years ago
How to buy SafeMoon for dummies guide by Kika Angelic
All Blogs & Seller News8 months ago
Amazon will be reimbursing millions of sellers over an error on their part
All Blogs & Seller News8 months ago
You would never think this could get you suspended! Amazon continues its wave of Buyer Account closures, learn what is new!
Amazon Seller News2 years ago
Why are fraudsters buying “Aged” Amazon Seller Accounts
Amazon Seller News9 months ago
What to do when your Amazon Seller Account gets placed on a hold?
Amazon Seller News1 year ago
The credit card or debit card Amazon myth busted once for ever
All Blogs & Seller News8 months ago
Watch out! Amazon is mercilessly cracking down on dropshipping!