Earn Money Writing an Original Article
Here’s a chance for you to earn money just by writing articles from the ease of sitting at home.
Anyone who has a hold on writing can send articles to us for approval to our website (www.thevortexcode.com). Please read the requirements if you are interested in writing articles.
Terms & Conditions / Requirements
What kind of content do we look for?Content that complements our existing web site content to enhance our members experience Latest Technology News Guidelines for the articlesNo plagiarism please. Don’t bother contacting us if you plan on using other people’s stuff. Spell [...]
The error “UNQ_SALES_FLAT_ORDER_INCREMENT_ID” is usually seen when magento uses alphanumeric order numbers. When the old customer buys a product again, magento instead of increasing the ordre increment from the latest order, increases the increment from the last order of the same old customer. This creates a duplicate entry and magento refuses to take an order.
You can also receive an email containing “SQLSTATE: Integrity constraint violation: 1062 Duplicate entry ‘AB100082765’ for key ‘UNQ_SALES_FLAT_ORDER_INCREMENT_ID‘” error or “There was an error processing your request” during placing [...]
As you have by now set your own magento store and you see that the order number a customer gets after purchasing starts from 100000001. But as its your new store and you don’t want your store to look like an amateur to others, you thought of changing the value of the order/shipment/invoice/credit memo number. But as you might have found out that there is no option in magento to change the value of this. Also it occurred to you that you want to modify in a way that it has a prefix related to your store name. e.g. Your store name is BestBooks.com, so you want that your order number looks like BB10023123. It looks definitely better than the default.
The states or provinces of India are not present by default in Magento 1.7 or older versions. If you want to include the states or territories in the checkout process or during registration, you will need to do it manually using SQL (phpMyAdmin). It’s an easy task taking less than a second to complete.
Note: Before continuing backup the database first, in case anything untoward happens, we can easily revert back.So here are the steps to include States or Provinces of India Inside Magento 1.7 or below:
1. Login to the Cpanel and go to phpMyAdmin
2. Select the database in which your magento installation is running.
3. Go to SQL.