Syscon Electro Tech India Private Limited’s Post

Discover the difference between Amazon barcodes and manufacturer barcodes! Our latest video breaks down how each impacts your brand's sales on Amazon. Don't miss out on this essential guide to optimize your product identification strategy. #ClickFluency #AmazonBarcodes #ManufacturerBarcodes #EcommerceTips #AmazonTips

He probably didn't hear of EMGA 60%OFF deals🔥 Save your money and buy all hi-tech EMGA devices from Amazon & Flipkart now🫵🏻 #DiscountOclock #EMGA #InnovationAddicts #TechDeals #UpgradeYourTech #NextLevelTech #BestDeals #Discounts #TechSavings #InnovationInTech #TechUpgrade #GrabYourDeal

Introducing Multi-Channel Fulfilment Outbound APIs Now fulfilling orders for your off-Amazon customers can be as easy as a few clicks! Introducing Multi-Channel Fulfilment (MCF) Outbound APIs, which have been developed to help you optimize your fulfilment process and provide an excellent customer experience. Your customers can browse your products available in Amazon’s fulfilment centres and view estimated delivery dates during the checkout process, just like customers on Amazon.in. After your customer purchases a product from you, an MCF fulfilment request can be created to process the order, and then the product is shipped with real-time tracking. Use this guide to enable MCF Outbound APIs on your systems. Are you new to MCF? Sign up here Amazon Seller Sell on Amazon #amazonseller #amazonsellercentral

Jeeves The innovators of customer service experience. Jeeves are excellent at finding innovative ways to harass customer. They have excellent people and process in place to commit trivial frauds. (These guys are pathetic at whatever they claim they do. Or I should say, they are brilliant at doing frauds.) While buying from Flipkart avoid items that are associated with extended warranty services provided via Jeeves. If possible avoid buying anything from Flipkart. I usually prefered Flipkart over any other E-comm for appliance, electronics, mobile buying. But they have deteriorated in Product quality and Customer service. #customerexperience #customerfeedback #customerservice #flipkart

🎯Brief, Quick, and Smart. “How my order comes to me” from #Amazon. They say - there is a method to the madness. #firstmile #middlemile #lastmile #Warehouseautomation #SolutionDesign #eCommerce #EyesOfaBox

UPC's, FNSKU's, ASIN's ... oh my! Do you know the difference between each of these? Navigating the barcode requirements for your products can be daunting, but mastering this can save you time and money. If you're looking to streamline your operations and cut costs, you won’t want to miss the latest video Arvin & I just dropped. 📊 In "Amazon Co-mingled Stickerless Barcodes: Manufacturer barcodes, ASIN's, FNSKU's and More," we break down everything you need to know about Amazon's barcode options. You'll learn the ins and outs of using manufacturer barcodes versus Amazon’s FNSKU, how to set up your products for co-mingled stickerless inventory, and tips to avoid common pitfalls that could cost you money. Check it out to get a better grip of Amazon's system and what the implications are for each of these identifiers. Have questions? Let us know in the comments 👇 #amazon #fnsku #upc #asin #amazonseller #producthaus https://lnkd.in/gC9nE5SY Product Haus

You wake up on a brisk, fall day in October. You grab your morning coffee and head outside to grab your Amazon order that you ordered just the night before and is already on your front porch. Have you ever wondered how e-commerce giants like Amazon ensure lightning-fast deliveries? The secret lies in optimizing order-picking processes! 📦🔍 🔍 The Challenge: Inefficient picking can lead to longer lead times, higher costs, and errors in order fulfillment. 🛠️ The Resolution: Embracing automation with Goods-to-Person tech, Pick-to-Light systems, and robotic picking arms can skyrocket efficiency. Optimization algorithms ensure that every step is a strategic move towards a seamless process. #WarehouseEfficiency #OrderPickingOptimization #AutomationRevolution #SupplyChainSolutions #LogisticsInnovation

🎯 100𝐝𝐚𝐲𝐬𝐬𝐪𝐥𝐜𝐡𝐚𝐥𝐥𝐞𝐧𝐠𝐞 📌 𝗗𝐚𝐲1/100  📢 𝐒𝐐𝐋 🚩𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻: For instance, if a customer named ABC has placed 4 orders and returned 3 of them, they should be included in the output. On the other hand, if a customer named XYZ has placed 5 orders but only returned 2, they should not be included in the output. Write an SQL to find list of customers along with their return percent(Round to 2 decimal places). 📌𝐒𝐐𝐋𝗰𝗼𝗱𝗲: 🔶𝗔𝗽𝗽𝗿𝗼𝗮𝗰𝗵-𝟭 WITH CTE_A AS ( SELECT Flipkart_tb.customer_name, COUNT(Flipkart_tb.order_id) as 'Total Order',COUNT(Flipkart_Return.order_id) as 'Return Count' --CAST (COUNT(Flipkart_Return.order_id) AS float) / CAST ( NULLIF(COUNT(Flipkart_Return.order_id),0) AS float) FROM Flipkart_tb LEFT JOIN Flipkart_Return ON Flipkart_tb.order_id=Flipkart_Return.order_id GROUP BY Flipkart_tb.customer_name ) SELECT customer_name, CAST (([Return Count]*1.0/[Total Order] * 1.0)*100 AS DECIMAL(4,0))   AS 'return_percent' FROM CTE_A WHERE CAST (([Return Count]*1.0/[Total Order] * 1.0)*100 AS DECIMAL(4,0))>=75.00 🔶𝗔𝗽𝗽𝗿𝗼𝗮𝗰𝗵-𝟮 SELECT Flipkart_tb.customer_name, (COUNT(Flipkart_tb.order_id)*1.00/COUNT(Flipkart_Return.order_id)*1.00) as 'Return Percent' FROM Flipkart_tb LEFT JOIN Flipkart_Return ON Flipkart_tb.order_id=Flipkart_Return.order_id GROUP BY Flipkart_tb.customer_name HAVING (COUNT(Flipkart_Return.order_id)*1.00/COUNT(Flipkart_Return.order_id)*1.00)>=75; 𝗦𝗼𝗹𝘂𝘁𝗶𝗼𝗻 Details can be found:- https://lnkd.in/e_CabzrH #sql100dayschallenge #sqlproblem #sql