I have a CSV sheet w/ all the appointments made at different locations which have the client ID number. I would like to take the client ID from the appointment table and match it with the Client Table to find out their name, number and email and which location they booked at.
I need a change to the magento module to display the brands of active products in a specific category
Hi. There is a task on the site: 1. The name of the category was multilanguage. 2. [login to view URL] also enter their name in multilingual depending on the language. 3. When viewing the category [login to view URL] from the side, display its subcategories and also multilanguage their name. 4. [login to view URL]
I am searching for a industrial designer specialized in consumer electronics to help me design my new electronic product.
Hi All i have a table like attached image needs first negative balance date followed by second last positive balance means 7769 . -3752...like attached image needs first negative balance date followed by second last positive balance means 7769 . -3752.86 2018-08-10 08:06:35 1 min job for expert send query in your reply budget : 500 INR
Mage...backend it is very slow especially in the use of feed generation and in the m2epro module. It is slow in any query related to the catalog. Especially if I have to filter the products. In the frontend the site is slow only the first time I visit a category. I need apache and mariadb to be optimized. The serve has 50g of RAM and is very powerful.
...want to add pagination to the category page in woocommerce. Below are the pages where i want to add pagination. 1) Add Pagination to the shop page (Shop page have categories no products) 2) Add Pagination to Category Page (Category page have subcategories) 3) Add pagination to A-Z listing (A-Z listing is for to call category by alphabetical) (Plugin used:
I have MongoDB collection. I have to group the documents in that collection based on the monthly cycle. For example, the cycle date is 20 of each month. I have to group the documents like 20/06/2018 to 19/07/2018 , 20/07/2018 to 19/08/2018.
No time waste please Only need to work using team viewer In wordpress dashboard admin panel under a custom post type "Meetings" the select category filter drop down is not working. its not showing category to select for filter. genuine bids and payment will be given only when task completed.
I need someone to write a simple sql query to copy fields between tables
Hi, i am looking for dropshipping lister tool
we have a form for insert data, we need on submit to create a query before to process to check if data exist and IF exist show a modal with alert and name of data else process
I need unique article links for my webiste from digitial marketing category
I need someone freelancer to help me to fix the query below: select count(distinct p.products_id) as total from (products p) left join manufacturers m on (m.manufacturers_id=p.manufacturers_id) left join specials s on p.products_id = s.products_id left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id left join zones_to_geo_zones gz on
I have some work, in an Excel spreadsheet.
Hi everyone, We're currently working on a website for a major office-supply company, and we need several writers to help us create category descriptions. Here's an example of one: Page title: Ablagesysteme & Aufbewahrungssysteme | [brand-name] In jedem funktionierenden Büro sind Ablage- und Aufbewahrungssysteme unerlässlich. Sie helfen dabei, komplexe
I'm building a secondhand record store and want to feature downloadable RTF files of products filtered by pre-set category, price and other custom attributes. The settings would be defined in the back-end by a plugin and displayed on the site using a shortcode.
Website for video uploads, business category, location, review of users need category wise image, search options , business name,category,location
Query on Office 365 Excel Online to export the data. No bootstrapping. Need to use Dojo or jQuery, or find a way to get it into that format for me to use.
MS Excel 3 year sales analysis by product category (pivot tables). Purpose is to find out which companies have purchased from 2016-2018 and the revenue change by each product category
Project Duration: 1 Hour Project Overview When trying to run this query: SET `description` = REPLACE(`description`, 'â€™', ''') WHERE `description` like 'â€™%' We get the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right synt...
I am currently getting a 500 error on my website. I traced it back to an SQL query (SELECT XYZ FROM zip_code INNER JOIN city ON zip_code.city_id = city.city_id INNER JOIN region ON city.region_id = region.region_id INNER JOIN country ON region.country_id = country.country_id). The INNER JOIN country ON region.country_id = country.country_id part of
Scrape from a google spreadsheet into a database on Azure or EC2, and create a UI for non-technical people to query. Make sure certain users can add but cannot delete data from the db. Also the UI should sanitize and validate the data before entering it int the database.
I have a quick issue I just need some advice on Fixing or a slight change of code. JSON Response is being presented to the app however, it won't append to the Dictionary that I'm trying to use. Paying a maximum of $30AUD for this as it is a quick code fix. Just needs a simple fix.
Select rows to display the columns: name of product/service assign alias as “ProductService”, quantity sold of product (invoice detail), employeeID who is assigned to the invoice; where the employee ID equals 1; sort by name of product/service ascending.
SELECT [login to view URL], SUM([login to view URL] * [login to view URL]) as price FROM Customers INNER JOIN Invoice ON [login to view URL] = [login to view URL] INNER JOIN InvoiceDetail ON [login to view URL] = [login to view URL] group BY [login to view URL] I CAN"T SEEM TO GET THE Customers.Firstname...etc... because of the SUM... I can get one or the other but not both...
I have a request table I need a few queries done on. This is an excel sheet. I need to find out quick analytics on our user behavior. It would be excellent to get the %, numbers and graphs depicting results.
This work involves a pdf file of shipping labels with multiple pages that needs to be sorted based on a reference number in a text file that matches a label/page within a pdf file.. ie A list of alpha numeric letters/numbers are given vertically in a text file that need to be searched within the pdf file and as the pdf file finds the queries within its pages (which is one per page), it creates a n...
I need you to build a landing page. budget 600 Rs
I am looking for an experienced Magento data import expert to help with import product data, creating the catalogue/category structure along with the attribute structure. Product file consists of approx 33,000 products, 600 categories and 730000 line of attributes. This will become clearer once you have eyes on the sample data. This is the first
...product category names and input into “category”, “sub-category”, and “sub sub category” columns of supplied .xls file. Please obtain the product category names from the PDF’s as per below: a. Top left page title – Main Category b. Top right page title – Sub Category c. If Top middle page ti...
I am using Classic Next Light (legacy theme) on BigCommerce as we want to keep the design and functionality very simple. However, I would like to display 2 categories of products on the homepage similar to the Dymo RX Labels which is currently listed on the domain [login to view URL] I was able to do the first one but I am not familiar with BigCommerce as I usually work with Shopify. I am looking...
At the moment i'm trying to write a category description at each category on our website. However, although in backend you can see the text, it isn't shown on the live website. I already put the code from the theme builders in Plesk. See screens for more information. Can someone tell me what is wrong here and how to fix it?
I have a query in place and would like to create a form with drop down boxes that allows the user to run the query based on the criteria they select. I have started the form but am struggling with linking the combo boxes to the query.